Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14300 to ORA-14324
- ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575
Action: Ensure that the partitioning key falls within 1048575 partitions or subpartitions.
Cause: While processing an ALTER TABLE ADD COLUMN statement, table-level attributes of LOB columns were encountered after processing partition-level attributes of LOB columns or while processing CREATE TABLE statement, table-level attributes of LOB columns were encountered after processing partition descriptions.
Action: Modify the SQL statement to specify table-level attributes prior to partition-level attributes or partition descriptions; then retry the statement.
Cause: While parsing an ALTER TABLE ADD COLUMN statement, one list of added-LOB-storage-clauses was parsed when another list of added-LOB-storage-clauses was encountered. There cannot be more than one list of added-LOB-storage-clauses in a statement; all added-LOB-storage-clauses must be combined into one list.
Action: Combine all of the lists of added-LOB-storage-clauses into one list and retry the statement.
Cause: User attempted to rebuild a partition of a Composite Range partitioned index which is illegal
Action: Re-order the partitions or subpartitions in the added LOB storage clause by partition or subpartition DDL order, and retry the statement.
Cause: number of columns in a partitioning column list exceeded the legal limit of 1 for List partitioned objects
Action: modify partitioning column list so that it consists of at most 1 column
Cause: A list value cannot be specified more that once
Action: Remove one of the specifications of the value
Cause: A list value cannot be specified more that once
Action: Remove one of the specifications of the value
Cause: Partition list contains more than 524288 list values
Action: Reduce the number of values to not exceed 524288 values
- ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL
Cause: Partition bound list contained an element of invalid type (i.e. not a number, non-empty string, datetime or interval literal, or NULL)
Action: Ensure that all elements of partition bound list are of valid type
Cause: Partitioned object contains more than 524288 list values
Action: Reduce number of values to less than 524288.
Cause: VALUES LESS THAN or AT clause can be used only with Range partitioned tables
Action: Use VALUES (value list) clause with List partitioned tables
Cause: VALUES (value list) clause can be used only with List partitioned tables
Action: Use VALUES LESS THAN clause with Range partitioned tables
Cause: One of the list values in the ADD PARTITION or ADD VALUES statement already exists in another partition
Action: Remove the duplicate value from the statement and try again
Cause: One of the list values in the SPLIT PARTITION or DROP VALUES statement does not exist in the partition
Action: Remove the value from the statement and try again
Cause: After a SPLIT/DROP VALUE of a list partition, each resulting partition(as applicable) must contain at least 1 value
Action: Ensure that each of the resulting partitions contains atleast 1 value
Cause: The same partition name was specified twice for the merge operation
Action: Re-submit operation with 2 distinct partition names
Cause: ALTER TABLE ADD|DROP VALUES can only be performed on List partitioned objects
Action: Re-issue the command against a List partitioned object.
Cause: ALTER TABLE DROP VALUES tried to drop the last value of the partition
Action: Cannot execute the command, unless two or more values exist for partition
Cause: A partition description follows the one describing the default partition
Action: Ensure that the DEFAULT partition is the last partition description
Cause: DEFAULT keyword has been specified along with other values when specifying the values for a list partition
Action: Ensure that if DEFAULT is specified, it is the only value specified
Cause: DEFAULT keyword has been specified when doing a ADD VALUES or DROP VALUES or SPLIT partition or subpartition.
Action: Ensure that DEFAULT is not specified for ADD/DROP VALUES or SPLIT partition/subpartition operation.
Cause: A ADD/DROP VALUES operation is being done on the default partition
Action: Ensure that ADD/DROP VALUES is not done on the DEFAULT partition
Cause: A partition already exists with DEFAULT value
Action: n/a
Cause: An ADD PARTITION operation cannot be executed when a partition with DEFAULT values exists
Action: Issue a SPLIT of the DEFAULT partition instead
Cause: An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT partition
Action: Issue a SPLIT of the DEFAULT partition and then MERGE the split partition into the partition to which values need to be added