Oracle Database Errors or Warnings from Error ORA-14084 to ORA-14100

SQLServerF1

ORA-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index
Cause: User attempted to specify TABLESPACE DEFAULT for an object other than a LOCAL index, which is illegal.
Action: Reenter the statement without TABLESPACE DEFAULT clause.
ORA-14085: partitioned table cannot have column with LONG datatype
Cause: User tried to create a partitioned table with a LONG datatype or tried to add a LONG datatype column to a partitioned table.
Action: LONG data types are not supported with partitioned tables. Create table without LONG column or change table to not partitioned. If adding column, do not use LONG datatype. If modifying attributes of a column to change data type to LONG, it has to be a non partitioned table.
ORA-14086: a partitioned index may not be rebuilt as a whole
Cause: User attempted to rebuild a partitioned index using ALTER INDEX REBUILD statement, which is illegal
Action: Rebuild the index a partition at a time (using ALTER INDEX REBUILD PARTITION) or drop and recreate the entire index

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option
Cause: Name of the table to be EXCHANGED has to be followed by [{INCLUDING|EXCLUDING} INDEX][{WITH|WITHOUT} VALIDATION]
Action: Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE PARTITION
ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
Cause: The table in the EXCHANGE operation is either clustered or partitioned
Action: Ensure that the table with which the partition is being exchanged for is not partitioned or clustered.
ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
Cause: The two tables specified in the EXCHANGE have different number of columns
Action: Ensure that the two tables have the same number of columns with the same type and size.

ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
Cause: The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE PARTITION are of different type or size
Action: Ensure that the two tables have the same number of columns with the same type and size.
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Cause: The two tables specified in the EXCHANGE have indexes which are not equivalent
Action: Ensure that the indexes for the two tables have indexes which follow this rule For every non partitioned index for the non partitioned table, there has to be an identical LOCAL index on the partitioned table and vice versa. By identical, the column position, type and size have to be the same.
ORA-14099: all rows in table do not qualify for specified partition
Cause: There is at least one row in the non partitioned table which does not qualify for the partition specified in the ALTER TABLE EXCHANGE PARTITION
Action: Ensure that all the rows in the segment qualify for the partition. Perform the alter table operation with the NO CHECKING option. Run ANALYZE table VALIDATE on that partition to find out the invalid rows and delete them.
ORA-14100: partition extended table name cannot refer to a remote object
Cause: User attempted to use partition-extended table name syntax in conjunction with remote object name which is illegal
Action: Correct the statement and reenter

Above are list of Oracle Database Errors or Warnings from Error ORA-14084 to ORA-14100 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 *