{"id":1850,"date":"2016-04-03T11:55:33","date_gmt":"2016-04-03T08:55:33","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1850"},"modified":"2016-10-24T11:57:23","modified_gmt":"2016-10-24T08:57:23","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12000-to-ora-12100","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12000-to-ora-12100\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12000 to ORA-12100"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12000 to ORA-12100<\/strong><\/p>\n

\n
ORA-12001: cannot create log: table ‘string’ already has a trigger<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view logs are filled by a trigger on the master table. That trigger cannot be created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To create a materialized view log, drop the current trigger on the master.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12002: there is no materialized view log on table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There was no materialized view log on the master table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a materialized view log on the master table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12003: materialized view “string<\/i>“.”string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view with the given owner and name does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify inputs and create a materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12004: REFRESH FAST cannot be used for materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12005: may not schedule automatic refresh for times in the past<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to schedule an automated materialized view refresh for a time in the past.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose a time in the future instead.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12007: materialized view reuse parameters are inconsistent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The CREATE MATERIALIZED VIEW .. or CREATE MATERIALIZED VIEW LOG .. REUSE command was given inconsistent parameters immediately after the REUSE.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the other messages on the stack to find the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12008: error in materialized view refresh path<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Table 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12010: cannot create materialized view log on table owned by SYS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create a materialized view log on SYS tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12011: execution of\u00a0string<\/i>\u00a0jobs failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was caught in dbms_ijob.run from one or more jobs which were due to be run.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Look at the alert log for details on which jobs failed and why.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12012: error on auto execute of job\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was caught while doing an automatic execution of a job.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Look at the accompanying errors for details on why the execute failed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12013: updatable materialized views must be simple enough to do fast refresh<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The updatable materialized view query contained a join, subquery, union, connect by, order by, or group by caluse.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make the materialized view simpler. If a join is really needed, make multiple simple materialized views then put a view on top of them.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12014: table ‘string<\/i>‘ does not contain a primary key constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the command using only the WITH ROWID option, create a primary key constraint on the master table, or enable an existing primary key constraint.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12015: cannot create a fast refresh materialized view from a complex query<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Neither ROWIDs and nor primary key constraints are supported for complex queries.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12016: materialized view does not include all primary key columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The query that instantiates the materialized view did not include all of the columns in the master’s primary key constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Include all of the master’s primary key columns in the materialized view query or create a ROWID materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12017: cannot alter primary key mview ‘string<\/i>‘ to a rowid mview<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to convert the primary key of a materialized view to a ROWID materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Conversion 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12018: following error encountered during code generation for “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The refresh operations for the indicated materialized view could not be regenerated due to errors.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem indicated in the following error messages and repeat the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12019: master table is a synonym to a remote object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a materialized view or a materialized view log on a remote synonym which is unsupported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create a materialized view or materialized view log on a remote synonym.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12020: materialized view\u00a0string<\/i>\u00a0is not registered<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to unregister a materialized view that is not registered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12021: materialized view “string<\/i>“.”string<\/i>” is corrupt<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view indicated is no longer valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12022: materialized view log on “string<\/i>“.”string<\/i>” already has rowid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view log on the indicated table already has ROWID information.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12023: missing index on materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified ROWID materialized view did not have the required index on the ROWID column of its underlying table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop and recreate the materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12024: materialized view log on “string<\/i>“.”string<\/i>” does not have primary key columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view log on the indicated table does not have primary key information.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add primary keys to the materialized view log using the ALTER MATERIALIZED VIEW command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12025: materialized view log on “string<\/i>“.”string<\/i>” already has primary keys<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view log on the indicated table already has primary key columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12026: invalid filter column detected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One or more of the specified filter columns did not exist or was a primary key column or a primary key based object identifier.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12027: duplicate filter column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One or more of the specified filter columns were already being recorded in the materialized view log.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Describe the materialized view log table and reissue the SQL command with the filter columns that are already being recorded in the materialized view log.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12028: materialized view type is not supported by master site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Pre-Oracle8 master sites are not able to support primary key or subquery materialized views that are able to perform a fast refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a ROWID materialized view or use a master table from an Oracle8 site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12029: LOB columns may not be used as filter columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use LOB columns as filter columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove LOB columns from the filter columns list and retry command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12030: cannot create a fast refresh materialized view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view log did not exist or did not log the information needed by the materialized view to perform a fast refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the materialized view log exists and logs the necessary information.<\/span><\/span><\/span><\/dd>\n
– For ROWID materialized views, the master table’s ROWID must be logged.<\/span><\/span><\/span><\/dd>\n
– For primary key materialized views, the master table’s primary key columns must be logged.<\/span><\/span><\/span><\/dd>\n
– For subquery materialized views, the filter columns, primary key, and ROWID values must be logged.<\/span><\/span><\/span><\/dd>\n
– For object materialized views, object id must be logged.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12031: cannot use primary key columns from materialized view log on “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0A complete refresh is required before the next fast refresh. Add primary key columns to the materialized view log, if required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12032: cannot use rowid column from materialized view log on “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0A complete refresh is required before the next fast refresh. Add ROWID columns to the materialized view log, if required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12033: cannot use filter columns from materialized view log on “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0A complete refresh is required before the next fast refresh. Add filter columns to the materialized view log, if required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12034: materialized view log on “string<\/i>“.”string<\/i>” younger than last refresh<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view log was younger than the last refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0A complete refresh is required before the next fast refresh.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12035: could not use materialized view log on “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view log did not exist or could not be used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12036: updatable materialized view log is not empty, refresh materialized view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12037: unknown export format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to import a materialized view exported by an unknown export version (e.g., from a newer release than the importing site)<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-export the file using a version of export known by the importing site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12039: unable to use local rollback segment “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either supply the automatic refresh parameters so that a refresh group will be created or do not specify a local rollback segment.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12040: master rollback segment option not support by master site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify a master rollback segment in the current operation or choose a new master site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12041: cannot record ROWIDs for index-organized table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Index-organized tables do not have ROWIDs. Therefore a materialized view log that records the ROWIDs of an index-organized table could not be created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12042: cannot alter job_queue_processes in single process mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter job_queue_processes in single process mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to set job_queue_processes in single process mode.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12043: invalid CREATE MATERIALIZED VIEW option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid option was used in a CREATE MATERIALIZED VIEW statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid option was used in a CREATE MATERIALIZED VIEW LOG statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid option was used in an ALTER MATERIALIZED VIEW LOG statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12046: cannot use trusted constraints for refreshing remote MV<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0REFRESH USING TRUSTED CONSTRAINTS specified in ALTER MATERIALIZED VIEW or CREATE MATERIALIZED VIEW of a remote materialized view<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0remove this attribute from ALTER\/ CREATE MATERIALIZED VIEW DDL<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12047: PCT FAST REFRESH cannot be used for materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PCT refresh is either not enabled on this materialized view or not possible after set of the base table changes since last refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use 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<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12048: error encountered while refreshing materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some problem occurs during refresh of multiple materialized views in atomic mode. The materialized view whose refresh failed has raised this error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the other messages on the stack to find the refresh problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12051: ON COMMIT attribute is incompatible with other options<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ON COMMIT refresh attribute, incompatible with other refresh options such as automatic periodic refresh, was specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12052: cannot fast refresh materialized view\u00a0string<\/i>.string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12053: this is not a valid nested materialized view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The list of objects in the FROM clause of the definition of this materialized view had some dependencies upon each other.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refer to the documentation to see which types of nesting are valid.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view did not satisfy conditions for refresh at commit time.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view query definition introduced a cyclic dependency with existing materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Modify the materialized view query definition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12056: invalid REFRESH method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The NEVER REFRESH option may not be used under the following conditions:<\/span><\/span><\/span><\/dd>\n
* The materialized view is updatable<\/span><\/span><\/span><\/dd>\n
* The materialized view refreshes ON COMMIT<\/span><\/span><\/span><\/dd>\n
* Automatic refresh options are specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0For 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12057: materialized view “string<\/i>“.”string<\/i>” is INVALID and must complete refresh<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Perform 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12058: materialized view cannot use prebuilt table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use the prebuilt tables.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the SQL command using BUILD IMMEDIATE or BUILD DEFERRED.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12059: prebuilt table “string<\/i>“.”string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified prebuilt table did not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the SQL command using BUILD IMMEDIATE, BUILD DEFERRED, or ensure that the prebuilt table exists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12060: shape of prebuilt table does not match definition query<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the SQL command using BUILD IMMEDIATE, BUILD DEFERRED, or ensure that the prebuilt table matches the materialized view definition query.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12061: invalid ALTER MATERIALIZED VIEW option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid option was used in an ALTER MATERIALIZED VIEW statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12062: transaction\u00a0string<\/i>\u00a0received out of sequence from site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A transaction from the client site was received out of sequence. This implies that one or more transactions were missing.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the transaction queue at the client site is valid and has not been corrupted.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12063: unable to apply transaction from site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current transaction from the client site could not be applied to the master site.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the client site is still valid and that it has not been dropped from the master site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12064: invalid refresh sequence number:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The client site was attempting to perform a refresh with an invalid refresh sequence.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Perform a complete refresh to synchronize the refresh sequence number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12065: unknown refresh group identifier\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified refresh group did not exist at the master site.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the client site is still valid and that it has not been dropped from the master site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12066: invalid CREATE MATERIALIZED VIEW command<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Replication API does not support the following options and types of materialized view:<\/span><\/span><\/span><\/dd>\n
o ROWID materialized views<\/span><\/span><\/span><\/dd>\n
o REFRESH ON COMMIT<\/span><\/span><\/span><\/dd>\n
o ON PREBUILT TABLE<\/span><\/span><\/span><\/dd>\n
o BUILD DEFERRED<\/span><\/span><\/span><\/dd>\n
o NEVER REFRESH<\/span><\/span><\/span><\/dd>\n
o ENABLE QUERY REWRITE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a PRIMARY KEY materialized view using REFRESH WITH PRIMARY KEY and\/or remove the invalid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12067: empty refresh groups are not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The refresh group being instantiated did not contain any materialized views.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Modify the template to include at least one materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12068: updatable mview log for mview “string<\/i>“.”string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The updatable materialized view was missing the updatable materialized view log required to track updates made to the materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the updatable materialized view log.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12069: invalid object for offline instantiation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only materialized views can be offline instantiated. The object being offline instantiated was not a valid materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the object from the template or replace the object with a valid materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12070: cannot offline instantiate materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Offline instantiation does not support materialized views using the following options:<\/span><\/span><\/span><\/dd>\n
o ON PREBUILT TABLE<\/span><\/span><\/span><\/dd>\n
o BUILD DEFERRED<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the invalid options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12071: definition query of “string<\/i>“.”string<\/i>” is invalid for offline instantiation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Offline instantiation requires materialized view definition queries to observe the following constraints:<\/span><\/span><\/span><\/dd>\n
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.<\/span><\/span><\/span><\/dd>\n
o All master tables referenced must be located at the local site. References to other sites are not allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Modify the materialized view definition query.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12072: updatable materialized view log data for “string<\/i>“.”string<\/i>” cannot be created<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The updatable materialized view was missing the updatable materialized view log required to track updates made to the materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create an updatable materialized view log.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12073: request cannot be processed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An out-of-sequence request was made and it cannot be processed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try again with a valid request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12074: invalid memory address<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access an invalid memory region.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reconnect and try the command again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12075: invalid object or field<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access an invalid field or object in the Java Virtual Memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12076: invalid threshold value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The result set threshold or LOB threshold value is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a threshold value below 64K.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12077: temporary updatable materialized view log does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Temporary updatable materialized view log was not created or was dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-create the temporary updatable materialized view log. Warning: This will cause a complete refresh of the materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12078: fast refresh of refresh group ID\u00a0string<\/i>\u00a0failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Refresh result set sent through client method REFRESH_REQ_RESULT returned an unknown value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the refresh request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12079: do not invalidate result cache created during materialized view refresh<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Result cache created during materialized view refresh was not invalidated at end.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not set this as an event.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12081: update operation not allowed on table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to update a read-only materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required. Only Oracle is allowed to update a read-only materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12082: “string<\/i>“.”string<\/i>” cannot be index organized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create an index-organized materialized aggregate view or an index-organized updatable ROWID materialized view. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try to create the materialized view without the index organization clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12083: must use DROP MATERIALIZED VIEW to drop “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a materialized view using a command other than DROP MATERIALIZED VIEW.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the DROP MATERIALIZED VIEW command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12084: must use ALTER MATERIALIZED VIEW to alter “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter a materialized view using a command other than ALTER MATERIALIZED VIEW.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the ALTER MATERIALIZED VIEW command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12085: materialized view log on “string<\/i>“.”string<\/i>” already has object id<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view log on the indicated table already has object id information.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12086: table “string<\/i>“.”string<\/i>” is not an object table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The CREATE MATERIALIZED VIEW LOG command was issued with the WITH OBJECT ID option and the master table is not an object table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify the name of an object table, or remove the WITH OBJECT ID clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12087: online redefinition not allowed on tables owned by “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to online redefine a table owned by SYS or SYSTEM.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to online redefine a table owned by SYS or SYSTEM.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12088: cannot online redefine table “string<\/i>“.”string<\/i>” with unsupported datatype<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to online redefine a table containing a LONG column, an ADT column, or a FILE column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to online redefine a table containing a LONG column, an ADT column, or a FILE column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12089: cannot online redefine table “string<\/i>“.”string<\/i>” with no primary key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to online redefine a table that does not have a primary key defined on it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to online redefine a table that does not have a primary key defined on it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12090: cannot online redefine table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to online redefine a table that is not supported by online redefinition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12091: cannot online redefine table “string<\/i>“.”string<\/i>” with materialized views<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all materialized views and materialized view logs before attempting to online redefine the table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12092: cannot online redefine replicated table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to online redefine a table that is either a materialized view or a replicated table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to online redefine a table that is either a materialized view or a replicated table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12093: invalid interim table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table is not the interim table of the corresponding table to be online redefined.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass in the valid interim table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12094: error during online redefinition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There was an error during the online redefinition process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Abort the online redefinition process.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12096: error in materialized view log on “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12097: changes in the master tables during refresh, try refresh again<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are some changes (i.e., conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refresh the affected materialized views again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12098: cannot comment on the materialized view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to issue a COMMENT ON TABLE statement on a materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue a COMMENT ON MATERIALIZED VIEW statement instead.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12100: materialized view log on “string<\/i>“.”string<\/i>” already has sequence<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Materialized view log on the indicated table already has sequence information.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action required.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12000 to ORA-12100 ORA-12001: cannot create log: table ‘string’ already has a trigger Cause:\u00a0Materialized view logs are filled by a trigger on the master table. That trigger cannot be created. Action:\u00a0To create a materialized view log, drop the current trigger on the master. ORA-12002: there is no…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1850","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-tQ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1850"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1850\/revisions"}],"predecessor-version":[{"id":1851,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1850\/revisions\/1851"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1850"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}