ORA-10906: Unable to extend segment after insert direct load
Cause: This is a restriction with insert direct load transactions.
Action: When a segment has been insert direct loaded, avoid DMLs that could cause more space to be consumed.
ORA-10914: invalid TABLESPACE GROUP clause
Cause: An invalid option appears for TABLESPACE GROUP clause.
Action: Specify a valid tablespace group name.
ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace
Cause: In CREATE/ALTER TABLESPACE, the TABLESPACE GROUP clause was used while creating/altering a tablespace that is not TEMPORARY.
Action: Remove the TABLESPACE GROUP clause.
ORA-10916: TABLESPACE GROUP already specified
Cause: In CREATE/ALTER TABLESPACE, the TABLESPACE GROUP option was specified more than once.
Action: Remove all but one of the TABLESPACE GROUP specifications.
ORA-10917: TABLESPACE GROUP cannot be specified
Cause: The tablespace name specified in the command is actually the name of a tablespace group.
Action: Please specify an appropriate tablespace name.
ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name
Cause: The tablespace group name specified in the command is the same as the tablespace being CREATEd/ALTERed.
Action: Please specify an appropriate tablespace group name.
ORA-10919: Default temporary tablespace group must have at least one tablespace
Cause: An attempt was made to move the only tablespace in the default database temporary tablespace group to another tablespace group.
Action: Either change the database default temporary tablespace or add another tablespace to the group that this tablespace belongs to.
ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group
Cause: An attempt was made to offline a tablespace in the default database temporary tablespace group.
Action: Either change the database default temporary tablespace or change the tablespace group of this tablespace.
ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group
Cause: An attempt was made to drop a tablespace in the default database temporary tablespace group.
Action: Either change the database default temporary tablespace or change the tablespace group of this tablespace.
ORA-10922: Temporary tablespace group is empty
Cause: An attempt was made to allocate a temporary segment in a group, which now no longer has any members.
Action: Either add some temporary tablespaces or change the temporary tablespace for this user.
ORA-10924: import storage parse error ignore event
Cause: causes server to ignore specific error associated with freelists and freelist groups when parsing
Action: this should be enabled by import code only
ORA-10925: trace name context forever
Cause: When enabled, turns off bugfix 237911
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10926: trace name context forever
Cause: When enabled, turns off bugfix 190119
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10927: trace name context forever
Cause: When enabled, turns off bugfix 235190
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10929: trace name context forever
Cause: When enabled, turns off bugfix 343966
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10930: trace name context forever
Cause: When enabled, provides V7 behavior for fixed char binds
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10931: trace name context forever
Cause: When enabled, allows normal packages to be compiled with standard extensions like "<ADT_1>"
Action: Set this event only for a short amount of time. Once the packages are compiled, this event should be turned off. Level 1 - Turn the event on Level > 1 - Turn the event off
ORA-10932: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10933: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10936: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available in versions 7.x and 8.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10940: trace name context forever
Cause: Size of the PL/SQL tracing circular buffer, in kilobytes.
Action: Set this event in concert with the 10938 event and the _PLSQL_DUMP_BUFFER_EVENTS init.ora parameter, under supervision of Oracle Support.
ORA-10941: trace name context forever
Cause: When enabled, turns on PL/SQL profiler
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10943: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10944: trace name context forever
Cause: When enabled, allows or controls PL/SQL OPT code gen project. available only in version 8.2+.
Action: set this event ONLY for development of the OPT project. This is not for general use or deployment.
ORA-10945: trace name context forever
Cause: When enabled, disables the behaviour change introduced by the fix for bug 822764, which traps and handles invalidations of packages whereas the previous behaviour was to use stale invalidated instantiations of the stateful package body.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10946: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 10.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10947: trace name context forever
Cause: When enabled, causes various PL/SQL warnings related debugging info to be written in a trace file. Useful for debugging varous Oracle processes. available only in version 10.x.
Action: set this event ONLY if necessary - after reading the README for this release or under supervision of Oracle Support.
ORA-10970: backout event for bug 2133357
Cause: 2133357 dynamically sets the varying width flag and character width. Lob data which is not migrated during migration from single byte to multibyte charater set will be displayed as special characters.
Action: To help migrate lob data which was not migrated during migration by backing out 2133357, so lob data can be selected and moved to multibyte character set.
ORA-10973: backout evet for 2619509
Cause: 2619509 catches offsets when not reading/writing on full character boundary. To facilitate backward compatiblity event is being introduced.
Action: To help upgrade/migrate issues which already have corrupt data
ORA-10979: trace flags for join index implementation
Cause: This is an informational message.
Action: Values are as follows: LEVEL ACTION --------------------------------------------------------------------------- > 1 Dump refresh expressions (SQL) to trace file. > 999 If a complete refresh is invoked, it will not be performed but the system will assume that a complete refresh was done, causing the view to be VALID and updating timestamps. This should be used only under Oracle Support supervision.
ORA-10997: another startup/shutdown operation of this instance inprogress
Cause: An Oracle Instance startup or shutdown operation failed to procure the serialization primitive. Another foreground process may have attempted startup or shutdown operation in parallel.
Action: Check additional error messages in the alert log and the process trace file.
ORA-12001: cannot create log: table 'string' already has a trigger
Cause: Materialized view logs are filled by a trigger on the master table. That trigger cannot be created.
Action: To create a materialized view log, drop the current trigger on the master.
ORA-12002: there is no materialized view log on table "string"."string"
Cause: There was no materialized view log on the master table.
Action: Create a materialized view log on the master table.
ORA-12003: materialized view "string"."string" does not exist
Cause: The materialized view with the given owner and name does not exist.
Action: Verify inputs and create a materialized view.
ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"
Cause: The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view
Action: Use just REFRESH, which will reinstantiate the entire table. If a materialized view log exists and the form of the materialized view allows the use of a materialized view log or PCT refresh is possible after a given set of changes, REFRESH FAST will be available starting the next time the materialized view is refreshed.
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.
Action: Choose a time in the future instead.
ORA-12007: materialized view reuse parameters are inconsistent
Cause: The CREATE MATERIALIZED VIEW .. or CREATE MATERIALIZED VIEW LOG .. REUSE command was given inconsistent parameters immediately after the REUSE.
Action: Examine the other messages on the stack to find the problem.
ORA-12008: error in materialized view refresh path
Cause: Table SNAP$_<mview_name> reads rows from the view MVIEW$_<mview_name>, which is a view on the master table (the master may be at a remote site). Any error in this path will cause this error at refresh time. For fast refreshes, the table <master_owner>.MLOG$_<master> is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_<mview_name>, MVIEW$_<mview_name>, <mowner>.<master>@<dblink>, <mowner>.MLOG$_<master>@<dblink> still exist.
ORA-12010: cannot create materialized view log on table owned by SYS
Cause: An attempt was made to create a materialized view log on the table owned by SYS. CREATE MATERIALIZED VIEW LOG attempts to create a trigger on the table, but triggers can not be created on SYS tables.
Action: Do not create a materialized view log on SYS tables.
ORA-12011: execution of string jobs failed
Cause: An error was caught in dbms_ijob.run from one or more jobs which were due to be run.
Action: Look at the alert log for details on which jobs failed and why.
ORA-12012: error on auto execute of job string
Cause: An error was caught while doing an automatic execution of a job.
Action: Look at the accompanying errors for details on why the execute failed.
ORA-12013: updatable materialized views must be simple enough to do fast refresh
Cause: The updatable materialized view query contained a join, subquery, union, connect by, order by, or group by caluse.
Action: Make the materialized view simpler. If a join is really needed, make multiple simple materialized views then put a view on top of them.
ORA-12014: table 'string' does not contain a primary key constraint
Cause: The CREATE MATERIALIZED VIEW LOG command was issued with the WITH PRIMARY KEY option and the master table did not contain a primary key constraint or the constraint was disabled.
Action: Reissue the command using only the WITH ROWID option, create a primary key constraint on the master table, or enable an existing primary key constraint.
ORA-12015: cannot create a fast refresh materialized view from a complex query
Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.
Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.
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.
Action: Include all of the master's primary key columns in the materialized view query or create a ROWID materialized view.
ORA-12017: cannot alter primary key mview 'string' to a rowid mview
Cause: An attempt was made to convert the primary key of a materialized view to a ROWID materialized view.
Action: Conversion of a primary key materialized view to a ROWID materialized view is not supported. Create a new materialized view with ROWIDs or drop and recreate the materialized view with ROWIDs.
ORA-12018: following error encountered during code generation for "string"."string"
Cause: The refresh operations for the indicated materialized view could not be regenerated due to errors.
Action: Correct the problem indicated in the following error messages and repeat the operation.
ORA-12019: master table is a synonym to a remote object
Cause: An attempt was made to create a materialized view or a materialized view log on a remote synonym which is unsupported.
Action: Do not create a materialized view or materialized view log on a remote synonym.
ORA-12020: materialized view string is not registered
Cause: An attempt was made to unregister a materialized view that is not registered.
Action: No action required.
ORA-12021: materialized view "string"."string" is corrupt
Cause: The materialized view indicated is no longer valid.
Action: Contact Oracle Customer Support.
ORA-12022: materialized view log on "string"."string" already has rowid
Cause: Materialized view log on the indicated table already has ROWID information.
Action: No action required.
ORA-12023: missing index on materialized view "string"."string"
Cause: The specified ROWID materialized view did not have the required index on the ROWID column of its underlying table.
Action: Drop and recreate the materialized view.
ORA-12024: materialized view log on "string"."string" does not have primary key columns
Cause: Materialized view log on the indicated table does not have primary key information.
Action: Add primary keys to the materialized view log using the ALTER MATERIALIZED VIEW command.
ORA-12025: materialized view log on "string"."string" already has primary keys
Cause: Materialized view log on the indicated table already has primary key columns.
Action: No action required.
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.
Action: Ensure that all specified filter columns exist in the master table and ensure that primary key columns or primary key based object identifiers are not included in the list of filter columns.
ORA-12027: duplicate filter column
Cause: One or more of the specified filter columns were already being recorded in the materialized view log.
Action: Describe the materialized view log table and reissue the SQL command with the filter columns that are already being recorded in the materialized view log.
ORA-12028: materialized view type is not supported by master site string
Cause: Pre-Oracle8 master sites are not able to support primary key or subquery materialized views that are able to perform a fast refresh.
Action: Create a ROWID materialized view or use a master table from an Oracle8 site.
ORA-12029: LOB columns may not be used as filter columns
Cause: An attempt was made to use LOB columns as filter columns.
Action: Remove LOB columns from the filter columns list and retry command.
ORA-12030: cannot create a fast refresh materialized view
Cause: The materialized view log did not exist or did not log the information needed by the materialized view to perform a fast refresh.
Action: Ensure that the materialized view log exists and logs the necessary information.
- For ROWID materialized views, the master table's ROWID must be logged.
- For primary key materialized views, the master table's primary key columns must be logged.
- For subquery materialized views, the filter columns, primary key, and ROWID values must be logged.
- For object materialized views, object id must be logged.
ORA-12031: cannot use primary key columns from materialized view log on "string"."string"
Cause: The materialized view log either did not have primary key columns logged, or the timestamp associated with the primary key columns was more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add primary key columns to the materialized view log, if required.
ORA-12032: cannot use rowid column from materialized view log on "string"."string"
Cause: The materialized view log either does not have ROWID columns logged, or the timestamp associated with the ROWID columns is more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add ROWID columns to the materialized view log, if required.
ORA-12033: cannot use filter columns from materialized view log on "string"."string"
Cause: The materialized view log either did not have filter columns logged, or the timestamp associated with the filter columns was more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add filter columns to the materialized view log, if required.
ORA-12034: materialized view log on "string"."string" younger than last refresh
Cause: The materialized view log was younger than the last refresh.
Action: A complete refresh is required before the next fast refresh.
ORA-12035: could not use materialized view log on "string"."string"
Cause: The materialized view log did not exist or could not be used.
Action: Use just REFRESH, which will reinstantiate the entire table. If a materialized view log exists and the form of the materialized view allows the use of a materialized view log, REFRESH FAST will be available starting the next time the materialized view is refreshed.
ORA-12036: updatable materialized view log is not empty, refresh materialized view
Cause: The updatable materialized view log was not empty. The updatable materialized view log must be empty before an updatable rowid materialized view can be altered to a primary key materialized view.
Action: Ensure that updatable materialized view log is empty by refreshing the materialized view before converting the updatable ROWID materialized view to a primary key materialized view.
ORA-12037: unknown export format
Cause: An attempt was made to import a materialized view exported by an unknown export version (e.g., from a newer release than the importing site)
Action: Re-export the file using a version of export known by the importing site.
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.
Action: Either supply the automatic refresh parameters so that a refresh group will be created or do not specify a local rollback segment.
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.
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-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-12043: invalid CREATE MATERIALIZED VIEW option
Cause: An invalid option was used in a CREATE MATERIALIZED VIEW statement.
Action: Specify only valid options.
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-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-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/ CREATE MATERIALIZED VIEW DDL
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-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-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-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-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-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-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-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-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-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-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-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-12061: invalid ALTER MATERIALIZED VIEW option
Cause: An invalid option was used in an ALTER MATERIALIZED VIEW statement.
Action: Specify only valid options.
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-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-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-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-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 remove the invalid options.
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-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-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-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-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-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-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-12074: invalid memory address
Cause: An attempt was made to access an invalid memory region.
Action: Reconnect and try the command again.
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-12076: invalid threshold value
Cause: The result set threshold or LOB threshold value is not supported.
Action: Specify a threshold value below 64K.
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-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-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-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-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-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-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-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-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-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-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-12090: cannot online redefine table "string"."string"
Cause: An attempt was made to online redefine a table that is either a temporary table, an IOT overflow table, a table with fine-grained access control or row-level security enabled, a CDC change table, or a table with a CDC change table defined on it.
Action: Do not attempt to online redefine a table that is not supported by online redefinition.
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.
No hay comentarios:
Publicar un comentario