Oracle Database Errors or Warnings from Error ORA-14131 to ORA-14140

SQLServerF1

ORA-14131: enabled UNIQUE constraint exists on one of the tables
Cause: One of the tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement has enabled UNIQUE constraint(s) defined on it, which prevents EXCHANGE from proceeding.
Action: Disable constraints defined on tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement and retry the statement.
ORA-14132: table cannot be used in EXCHANGE
Cause: An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command, but the non-partitioned table cannot be used in the EXCHANGE because one or more of the following apply:
– it is a typed table

– it is a temporary table

– it contains ADT columns

– it contains nested-table columns

– it contains REF columns

– it contains array columns

– it is an index-organized table

– it contains LOB columns

– it is a nested table

– it is created with row dependency and the partitioned table is not

– it is created without row dependency and the partitioned table is

Action: Make sure the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command.
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
Cause: An attempt was made to combine an ALTER TABLE MOVE statement with another operation, such as MODIFY.
Action: Make sure that MOVE is the only operation specified in ALTER TABLE statement;

ORA-14134: indexes cannot use both DESC and REVERSE
Cause: An attempt was made to make a reverse index with some index columns marked DESC.
Action: Do not use DESC in reverse indexes. The rule-based optimizer can scan indexes backwards, which allows a normal reverse index to simulate a reverse index with columns marked DESC.
ORA-14135: a LOB column cannot serve as a partitioning column
Cause: An attempt was made to specify a column of type BLOB or CLOB as a partitioning or subpartitioning column.
Action: Ensure that no partitioning or subpartitioning column is of type BLOB or CLOB.
ORA-14136: ALTER TABLE EXCHANGE restricted by fine-grained security
Cause: User doing exchange does not have full table access due to VPD policies.
Action: Grant exempt priviliges to this user.

ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE
Cause: An attempt was made to access a partitioned table in a partially dropped state.
Action: Submit DROP TABLE <table> PURGE to drop the table.
ORA-14138: An unexpected error encountered during drop table operation
Cause: Drop table encountered an unexpected error.
Action: a. Submit drop table <table> purge, or b. If the situation described in the next error on the stack can be corrected, do so. c. Contact Oracle Support.
ORA-14139: table string.string is already in read-only mode
Cause: an attempt was made to set a read-only table in read-only mode
Action: this DDL can only be executed on a read/write table
ORA-14140: table string.string is already in read/write mode
Cause: an attempt was made to set a read/write table in read/write mode
Action: this DDL can only be executed on a read-only table

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

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database 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 *