You are here: Home // Oracle 11g // ORA-12066: invalid CREATE MATERIALIZED VIEW command

ORA-12066: invalid CREATE MATERIALIZED VIEW command

Posted by Oracle 11g Release 2 on Dec 15, 2005 | Leave a Comment

Cause: The Replication API does not support the following options and types of materialized view:
  • ROWID materialized views
  • REFRESH ON COMMIT
  • ON PREBUILT TABLE
  • BUILD DEFERRED
  • NEVER REFRESH
  • ENABLE QUERY REWRITE
See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Obozy kitesurfingowe w Jastarni wideofilmowanie warszawa Hearing Aids kursy angielskiego dla dorosłych filmy