ORA-07503: scgcmn: $setimr unexpected return

ORA-07503: scgcmn: $setimr unexpected return

Cause: VMS system service $SETIMR returned an unexpected value

Action: Check for system error message and refer to VMS documentation

ORA-07502: scgcmn: $enq unexpected return

ORA-07502: scgcmn: $enq unexpected return

Cause: VMS system service $ENQ returned an unexpected value

Action: Check for system error message and refer to VMS documentation

ORA-07501: scgtoa: $deq unexpected return

ORA-07501: scgtoa: $deq unexpected return

Cause: VMS system service $DEQ returned an unexpected value

Action: Check for system error message and refer to VMS documentation

ORA-07500: scglaa: $cantim unexpected return

ORA-07500: scglaa: $cantim unexpected return

Cause: VMS system service $CANTIM returned an unexpected value

Action: Check for system error message and refer to VMS documentation

ORA-12100: materialized view log on string . string already has sequence

ORA-12100: materialized view log on string . string already has sequence

Cause: Materialized view log on the indicated table already has sequence information.

Action: No action required.

ORA-12098: cannot comment on the materialized view

ORA-12098: cannot comment on the materialized view

Cause: An attempt was made to issue a COMMENT ON TABLE statement on a materialized view.

Action: Issue a COMMENT ON MATERIALIZED VIEW statement instead.

ORA-12097: changes in the master tables during refresh, try refresh again

ORA-12097: changes in the master tables during refresh, try refresh again

Cause: There are some changes (i.e., conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.

Action: Refresh the affected materialized views again.

ORA-12096: error in materialized view log on string . string

ORA-12096: error in materialized view log on string . string

Cause: There was an error originating from this materialized view log. One possible cause is that schema redefinition has occurred on the master table and one or more columns in the log is now a different type than corresponding master column(s). Another possible cause is that there is a problem accessing the underlying materialized view log table.

Action: Check further error messages in stack for more detail about the cause. If there has been schema redefinition, drop the materialized view log and recreate it.

ORA-12094: error during online redefinition

ORA-12094: error during online redefinition

Cause: There was an error during the online redefinition process.

Action: Abort the online redefinition process.

ORA-12093: invalid interim table string . string

ORA-12093: invalid interim table string . string

Cause: The table is not the interim table of the corresponding table to be online redefined.

Action: Pass in the valid interim table.

ORA-12092: cannot online redefine replicated table string . string

ORA-12092: cannot online redefine replicated table string . string

Cause: An attempt was made to online redefine a table that is either a materialized view or a replicated table.

Action: Do not attempt to online redefine a table that is either a materialized view or a replicated table.

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

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.

Action: Drop all materialized views and materialized view logs before attempting to online redefine the table.

ORA-12090: cannot online redefine table string . string

ORA-12090: cannot online redefine table string . string

Cause: An attempt was made to online redefine a table that is either a clustered table, AQ table, temporary table, IOT overflow table or table with FGA or RLS enabled.

Action: Do not attempt to online redefine a table that is a clustered table, AQ table, temporary table, IOT overflow table or table with FGA or RLS enabled.

ORA-12089: cannot online redefine table string . string with no primary key

ORA-12089: cannot online redefine table string . string with no primary key

Cause: An attempt was made to online redefine a table that does not have a primary key defined on it.

Action: Do not attempt to online redefine a table that does not have a primary key defined on it.

ORA-12088: cannot online redefine table string . string with unsupported datatype

ORA-12088: cannot online redefine table string . string with unsupported datatype

Cause: An attempt was made to online redefine a table containing a LONG column, an ADT column, or a FILE column.

Action: Do not attempt to online redefine a table containing a LONG column, an ADT column, or a FILE column.

ORA-12087: online redefinition not allowed on tables owned by string

ORA-12087: online redefinition not allowed on tables owned by string

Cause: An attempt was made to online redefine a table owned by SYS or SYSTEM.

Action: Do not attempt to online redefine a table owned by SYS or SYSTEM.

ORA-12086: table string . string is not an object table

ORA-12086: table string . string is not an object table

Cause: The CREATE MATERIALIZED VIEW LOG command was issued with the WITH OBJECT ID option and the master table is not an object table.

Action: Either specify the name of an object table, or remove the WITH OBJECT ID clause.

ORA-12085: materialized view log on string . string already has object id

ORA-12085: materialized view log on string . string already has object id

Cause: Materialized view log on the indicated table already has object id information.

Action: No action required.

ORA-12084: must use ALTER MATERIALIZED VIEW to alter string . string

ORA-12084: must use ALTER MATERIALIZED VIEW to alter string . string

Cause: An attempt was made to alter a materialized view using a command other than ALTER MATERIALIZED VIEW.

Action: Use the ALTER MATERIALIZED VIEW command.

ORA-12083: must use DROP MATERIALIZED VIEW to drop string . string

ORA-12083: must use DROP MATERIALIZED VIEW to drop string . string

Cause: An attempt was made to drop a materialized view using a command other than DROP MATERIALIZED VIEW.

Action: Use the DROP MATERIALIZED VIEW command.

ORA-12082: string . string cannot be index organized

ORA-12082: string . string cannot be index organized

Cause: An attempt was made to create an index-organized materialized aggregate view or an index-organized updatable ROWID materialized view. This is not supported.

Action: Try to create the materialized view without the index organization clause.

ORA-12081: update operation not allowed on table string . string

ORA-12081: update operation not allowed on table string . string

Cause: An attempt was made to update a read-only materialized view.

Action: No action required. Only Oracle is allowed to update a read-only materialized view.

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

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

Cause: The following materialized view options require 8.1 or higher compatibility setting: o ON COMMIT o ON PREBUILT TABLE o BUILD DEFERRED o NEVER REFRESH o ENABLE QUERY REWRITE The following materialized view options require 8.2 or higher compatibility setting: o materialized views with user-defined types The following materialized view options require 9.2 or higher o materialized views (query rewrite enabled) with set operators that are not inside an inline view or named view The following materialized view options require 10.0 or higher o materialized views which can be refreshed USING TRUSTED CONSTRAINTS o materialized views with SELECT column alias clause In addition, ALTER MATERIALIZED VIEW LOG can be used to add sequence number only if compatibility is set to 10.0 or higher

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

ORA-12078: fast refresh of refresh group ID string failed

ORA-12078: fast refresh of refresh group ID string failed

Cause: Refresh result set sent through client method REFRESH_REQ_RESULT returned an unknown value.

Action: Re-issue the refresh request.

ORA-12077: temporary updatable materialized view log does not exist

ORA-12077: temporary updatable materialized view log does not exist

Cause: Temporary updatable materialized view log was not created or was dropped.

Action: Re-create the temporary updatable materialized view log. Warning: This will cause a complete refresh of the materialized view.

ORA-12076: invalid threshold value

ORA-12076: invalid threshold value

Cause: The result set threshold or LOB threshold value is not supported.

Action: Specify a threshold value below 64K.

ORA-12075: invalid object or field

ORA-12075: invalid object or field

Cause: An attempt was made to access an invalid field or object in the Java Virtual Memory.

Action: Retry the request.

ORA-12074: invalid memory address

ORA-12074: invalid memory address

Cause: An attempt was made to access an invalid memory region.

Action: Reconnect and try the command again.

ORA-12073: request cannot be processed

ORA-12073: request cannot be processed

Cause: An out-of-sequence request was made and it cannot be processed.

Action: Try again with a valid request.

ORA-12072: updatable materialized view log data for string . string cannot be created

ORA-12072: updatable materialized view log data for string . string cannot be created

Cause: The updatable materialized view was missing the updatable materialized view log required to track updates made to the materialized view.

Action: Create an updatable materialized view log.

ORA-12071: definition query of string . string is invalid for offline instantiation

ORA-12071: definition query of string . string is invalid for offline instantiation

Cause: Offline instantiation requires materialized view definition queries to observe the following constraints: o The database link that will be used by the materialized view site to connect to the master site must be included with each master table referenced in the query. o All master tables referenced must be located at the local site. References to other sites are not allowed.

Action: Modify the materialized view definition query.

ORA-12070: cannot offline instantiate materialized view string . string

ORA-12070: cannot offline instantiate materialized view string . string

Cause: Offline instantiation does not support materialized views using the following options: o ON PREBUILT TABLE o BUILD DEFERRED

Action: Remove the invalid options.

ORA-12069: invalid object for offline instantiation

ORA-12069: invalid object for offline instantiation

Cause: Only materialized views can be offline instantiated. The object being offline instantiated was not a valid materialized view.

Action: Remove the object from the template or replace the object with a valid materialized view.

ORA-12068: updatable mview log for mview string . string does not exist

ORA-12068: updatable mview log for mview string . string does not exist

Cause: The updatable materialized view was missing the updatable materialized view log required to track updates made to the materialized view.

Action: Create the updatable materialized view log.

ORA-12067: empty refresh groups are not allowed

ORA-12067: empty refresh groups are not allowed

Cause: The refresh group being instantiated did not contain any materialized views.

Action: Modify the template to include at least one materialized view.

ORA-12066: invalid CREATE MATERIALIZED VIEW command

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 views o REFRESH ON COMMIT o ON PREBUILT TABLE o BUILD DEFERRED o NEVER REFRESH o ENABLE QUERY REWRITE

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

ORA-12065: unknown refresh group identifier string

ORA-12065: unknown refresh group identifier string

Cause: The specified refresh group did not exist at the master site.

Action: Ensure that the client site is still valid and that it has not been dropped from the master site.

ORA-12064: invalid refresh sequence number: string

ORA-12064: invalid refresh sequence number: string

Cause: The client site was attempting to perform a refresh with an invalid refresh sequence.

Action: Perform a complete refresh to synchronize the refresh sequence number.

ORA-12063: unable to apply transaction from site string

ORA-12063: unable to apply transaction from site string

Cause: The current transaction from the client site could not be applied to the master site.

Action: Ensure that the client site is still valid and that it has not been dropped from the master site.

ORA-12062: transaction string received out of sequence from site string

ORA-12062: transaction string received out of sequence from site string

Cause: A transaction from the client site was received out of sequence. This implies that one or more transactions were missing.

Action: Ensure that the transaction queue at the client site is valid and has not been corrupted.

ORA-12061: invalid ALTER MATERIALIZED VIEW option

ORA-12061: invalid ALTER MATERIALIZED VIEW option

Cause: An invalid option was used in an ALTER MATERIALIZED VIEW statement.

Action: Specify only valid options.

ORA-12060: shape of prebuilt table does not match definition query

ORA-12060: shape of prebuilt table does not match definition query

Cause: The number of columns or the type or the length semantics of a column in the prebuilt table did not match the materialized view definition query.

Action: Reissue the SQL command using BUILD IMMEDIATE, BUILD DEFERRED, or ensure that the prebuilt table matches the materialized view definition query.

ORA-12059: prebuilt table string . string does not exist

ORA-12059: prebuilt table string . string does not exist

Cause: The specified prebuilt table did not exist.

Action: Reissue the SQL command using BUILD IMMEDIATE, BUILD DEFERRED, or ensure that the prebuilt table exists.

ORA-12058: materialized view cannot use prebuilt table

ORA-12058: materialized view cannot use prebuilt table

Cause: An attempt was made to use the prebuilt tables.

Action: Reissue the SQL command using BUILD IMMEDIATE or BUILD DEFERRED.

ORA-12057: materialized view string . string is INVALID and must complete refresh

ORA-12057: materialized view string . string is INVALID and must complete refresh

Cause: The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.

Action: Perform a complete refresh of the materialized view. Check the value of the STATUS column in dba_mviews, all_mviews, or user_mviews to verify that the materialized view is VALID after the complete refresh.

ORA-12056: invalid REFRESH method

ORA-12056: invalid REFRESH method

Cause: The NEVER REFRESH option may not be used under the following conditions: * The materialized view is updatable * The materialized view refreshes ON COMMIT * Automatic refresh options are specified

Action: For updatable materialized views, reissue the SQL command using REFRESH FORCE, REFRESH FAST, or REFRESH COMPLETE. For read-only materialized views, reissue the SQL command using ON DEMAND.

ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views

ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views

Cause: The materialized view query definition introduced a cyclic dependency with existing materialized view.

Action: Modify the materialized view query definition.

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

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.

Action: Specify only valid options.

ORA-12053: this is not a valid nested materialized view

ORA-12053: this is not a valid nested materialized view

Cause: The list of objects in the FROM clause of the definition of this materialized view had some dependencies upon each other.

Action: Refer to the documentation to see which types of nesting are valid.

ORA-12052: cannot fast refresh materialized view string.string

ORA-12052: cannot fast refresh materialized view string.string

Cause: Either ROWIDs of certain tables were missing in the definition or the inner table of an outer join did not have UNIQUE constraints on join columns.

Action: Specify the FORCE or COMPLETE option. If this error is got during creation, the materialized view definition may have be changed. Refer to the documentation on materialized views.

ORA-12051: ON COMMIT attribute is incompatible with other options

ORA-12051: ON COMMIT attribute is incompatible with other options

Cause: ON COMMIT refresh attribute, incompatible with other refresh options such as automatic periodic refresh, was specified.

Action: Specify only valid options.

ORA-12048: error encountered while refreshing materialized view string . string

ORA-12048: error encountered while refreshing materialized view string . string

Cause: Some problem occurs during refresh of multiple materialized views in atomic mode. The materialized view whose refresh failed has raised this error.

Action: Examine the other messages on the stack to find the refresh problem.

ORA-12047: PCT FAST REFRESH cannot be used for materialized view string. string

ORA-12047: PCT FAST REFRESH cannot be used for materialized view string. string

Cause: PCT refresh is either not enabled on this materialized view or not possible after set of the base table changes since last refresh.

Action: Use just REFRESH FORCE, which will reinstantiate the entire table and try to pick the best refresh method on the materialized view Do explain_mview to look at the cause why PCT refresh is not possible on this materialized view

ORA-12046: cannot use trusted constraints for refreshing remote MV

ORA-12046: cannot use trusted constraints for refreshing remote MV

Cause: REFRESH USING TRUSTED CONSTRAINTS specified in ALTER MATERIALIZED VIEW or CREATE MATERIALIZED VIEW of a remote materialized view

Action: remove this attribute from ALTER or CREATE MATERIALIZED VIEW DDL

ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

Cause: An invalid option was used in an ALTER MATERIALIZED VIEW LOG statement.

Action: Specify only valid options.

ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

Cause: An invalid option was used in a CREATE MATERIALIZED VIEW LOG statement.

Action: Specify only valid options.

ORA-12043: invalid CREATE MATERIALIZED VIEW option

ORA-12043: invalid CREATE MATERIALIZED VIEW option

Cause: An invalid option was used in a CREATE MATERIALIZED VIEW statement.

Action: Specify only valid options.

ORA-12042: cannot alter job_queue_processes in single process mode

ORA-12042: cannot alter job_queue_processes in single process mode

Cause: An attempt was made to alter job_queue_processes in single process mode.

Action: Do not attempt to set job_queue_processes in single process mode.

ORA-12041: cannot record ROWIDs for index-organized table string . string

ORA-12041: cannot record ROWIDs for index-organized table string . string

Cause: Index-organized tables do not have ROWIDs. Therefore a materialized view log that records the ROWIDs of an index-organized table could not be created.

Action: Do not include the WITH ROWID option when using the CREATE MATERIALIZED VIEW command and do not include the ADD ROWID option when using the ALTER MATERIALIZED VIEW command if the master table is index-organized.

ORA-12040: master rollback segment option not support by master site string

ORA-12040: master rollback segment option not support by master site string

Cause: An attempt was made to specify master rollback segment in the current operation. The master site of the current materialized view does not allow users to specify a rollback segment to be used for materialized view operations. This feature is only supported by Oracle8 or later master sites.

Action: Do not specify a master rollback segment in the current operation or choose a new master site.