Oracle database error code ORA-12066 – invalid CREATE MATERIALIZED VIEW command

Oracle Database Error Code ORA-12066 Description :
invalid CREATE MATERIALIZED VIEW command
Error Cause:
The Replication API does not support the following options and types of materialized view: o ROWID materialized views o REFRESH ON COMMIT o ON PREBUILT TABLE o BUILD DEFERRED o NEVER REFRESH o ENABLE QUERY REWRITE

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»