Oracle Database Errors or Warnings from Error ORA-42014 to ORA-42023

SQLServerF1

ORA-42014: online redefinition unable to lock AQ objects
Cause: An online redefinition of an AQ table was unable to lock all related AQ objects.
Action: Abort and retry the redefinition.
ORA-42015: online redefinition unable to log changes made to AQ tables
Cause: An online redefinition of an AQ table was unable to log changes made to AQ tables during the redefinition.
Action: Abort and retry the redefinition.
ORA-42016: shape of interim table does not match specified column mapping
Cause: The number of columns, or the type or the length semantics of a column, in the interim table did not match the specified column mapping.
Action: Ensure that the interim table matches the column mapping by either modifying the column mapping string or altering the interim table’s column definition(s).

ORA-42017: interim table of an AQ table should not be an AQ table
Cause: An attempt was made to create an AQ table as an interim table of an online redefined AQ table.
Action: Ensure that the interim table is not created as an AQ table.
ORA-42018: partition cannot be redefined online because of index organization incompatibility
Cause: interim table is incompatible with partition being redefined because one or more of the following apply:
– one is index-organized and the other is not

– one has IOT overflow segment and the other does not

– one has IOT mapping table and the other does not

Action: Ensure that the interim table is compatible with the partition being redefined.
ORA-42019: partition cannot be redefined online because of incompatible partitioning of interim table
Cause: both original and interim tables are partitioned, or original table is composite-partitioned but interim table is non-partitioned.
Action: Ensure that the interim table has compatible partitioning with the original table. For example, if the original table is partitioned, the interim table should be non-partitioned. If the original table is composite-partitioned, the interim table should be partitioned.

ORA-42020: partition cannot be redefined online because of unsupported type of interim table
Cause: An unsupported type of interim table was provided during the partition redefinition. Currently the following types of interim tables are not supported:
– a nested table or has nested-table columns

– an external table

– part of cluster

– contains LOB shared segments

Action: Do not use unsupported types of interim tables.
ORA-42021: partition cannot be redefined online because of incompatible row dependencies
Cause: original/interim table was created with row dependency and interim/original table was not.
Action: Ensure that both tables are created with same row dependency properties.
ORA-42022: partition cannot be redefined online because of presence of nested columns
Cause: An attempt was made to online redefine a partition with nested table columns.
Action: Do not attempt to online redefine a partition with nested table columns.
ORA-42023: compatibility of AQ table must be release 8.1.x or later
Cause: An attempt was made to perform online redefinition on an AQ table that was created with compatibility prior to release 8.1.x.
Action: Ensure that the AQ table is created with the COMPATIBLE parameter set to release 8.1.x or later before attempting online redefinition.

Above are list of Oracle Database Errors or Warnings from Error ORA-42014 to ORA-42023 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *