Error List

Error List for the ‘ORA-09858 to ORA-12299’ Category

ORA-12015 cannot create a fast refresh materialized view from a complex query

Description:
ORA-12015 cannot create a fast refresh materialized view from a complex query

Cause:
Neither ROWIDs nor primary key constraints are supported for complex queries.

ORA-09858 to ORA-12299 , ,

ORA-12054 cannot set the ON COMMIT refresh attribute for the materialized view

Description:
ORA-12054 cannot set the ON COMMIT refresh attribute for the materialized view

Cause:
The materialized view did not satisfy conditions for refresh at commit time.

ORA-09858 to ORA-12299 ,

ORA-12091 cannot online redefine table "string"."string" with materialized views

Description:
ORA-12091 cannot online redefine table “string“.”string” with materialized views

Cause:
An attempt was made to online redefine a table that had materialized views defined on it or had a materialized view log defined on it or is a master.

ORA-09858 to ORA-12299 ,

ORA-10642 Found rollback segments in dictionary managed tablespaces

Description:
ORA-10642 Found rollback segments in dictionary managed tablespaces

Cause:
When SYSTEM tablespace is migrated, found rollback segments in dictionary managed tablespaces.

ORA-09858 to ORA-12299

ORA-12026 invalid filter column detected

Description:
ORA-12026 invalid filter column detected

Cause:
One or more of the specified filter columns did not exist or was a primary key column or a primary key based object identifier.

ORA-09858 to ORA-12299 , , , ,

ORA-12066 invalid CREATE MATERIALIZED VIEW command

Description:
ORA-12066 invalid CREATE MATERIALIZED VIEW command

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

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

ORA-09858 to ORA-12299 , , , , , ,

ORA-12005 may not schedule automatic refresh for times in the past

Description:
ORA-12005 may not schedule automatic refresh for times in the past

Cause:
An attempt was made to schedule an automated materialized view refresh for a time in the past.

ORA-09858 to ORA-12299 , , ,

ORA-12039 unable to use local rollback segment "string"

Description:
ORA-12039 unable to use local rollback segment “string

Cause:
A local rollback segment was specified in the CREATE MATERIALIZED VIEW command, but automatic refresh parameters were not specified. Therefore a refresh group was not created to automatically refresh the materialized view and the local rollback segment can’t be registered for future use.

ORA-09858 to ORA-12299

ORA-12079 materialized view options require COMPATIBLE parameter to be string or greater

Description:
ORA-12079 materialized view options require COMPATIBLE parameter to be string or greater

Cause:
The following materialized view options require an 8.1 or higher compatibility setting:

  • ON COMMIT
  • ON PREBUILT TABLE
  • BUILD DEFERRED
  • NEVER REFRESH
  • ENABLE QUERY REWRITE

The following materialized view options require a 9.0.0 or higher compatibility setting:

  • materialized views with user-defined types

Action: Shut down and restart with an appropriate compatibility setting.

ORA-09858 to ORA-12299 , ,

ORA-12016 materialized view does not include all primary key columns

Description:
ORA-12016 materialized view does not include all primary key columns

Cause:
The query that instantiates the materialized view did not include all of the columns in the master’s primary key constraint.

ORA-09858 to ORA-12299 , , , , , ,