ORA-12028: materialized view type is not supported by master
site string



ORA-12028: materialized view type is not supported by master site string..

Answer / guest

Cause: Pre-Oracle8 master sites are not able to support
primary key or subquery materialized views that are able to
perform a fast refresh.

Action: Create a ROWID materialized view or use a master
table from an Oracle8 site.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02333: SQL identifier was not declared as a statement

1 Answers  


ORA-00991: only MAC privileges may be granted to procedures

1 Answers  


NNL-00577: list_domains: list authoritative domains in the region or subtree

1 Answers  


ORA-02095: specified initialization parameter cannot be modified

1 Answers  


ORA-12439: invalid combination of policy options

1 Answers  






ORA-19733: COMPATIBLE parameter needs to be string or greater

1 Answers  


ORA-04011: sequence string must range between string and string

1 Answers  


ORA-31627: API call succeeded but more information is available

1 Answers  


ORA-39305: specified schema "string" does not exist

1 Answers  


ORA-06720: TLI Driver: SID lookup failure

1 Answers  


ORA-29741: IMR active for some, but not all members of cluster

1 Answers  


RMAN-06193: connected to target database (not started)

3 Answers  


Categories