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

LPX-00323: illegal apply-imports because of no current template: ~s

1 Answers  


ORA-12426: invalid audit option

1 Answers  


IMG-00808: unable to read an empty image

1 Answers  


ORA-13638: The user interrupted the current operation.

1 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  






ORA-12558: TNS:protocol adapter not loaded

1 Answers  


ORA-00029: session is not a user session

1 Answers  


ORA-24410: scrollable cursor max size exceeded

1 Answers  


ORA-02851: Request list is empty when it should not be

1 Answers  


TNS-04203: Trace Assistant Usage ERROR: Invalid options

1 Answers  


SQL*Loader-00910: Error binding input variables for upi: [number]

1 Answers  


RMAN-07508: cataloging done

2 Answers   Excellence, TCS,


Categories