Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-12066: invalid CREATE MATERIALIZED VIEW command
Oracle® Database Error ORA-12066308/10

ORA-12066: invalid CREATE MATERIALIZED VIEW command

Cause: The Replication API does not support the following options and types of materialized view:o ROWID materialized viewso REFRESH ON COMMITo ON PREBUILT TABLEo BUILD DEFERREDo NEVER REFRESHo ENABLE QUERY REWRITE

Action: Create a PRIMARY KEY materialized view using REFRESH WITH PRIMARY KEY and/or remove the invalid options.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle