Oracle Database Errors or Warnings from Error ORA-14010 to ORA-14019

SQLServerF1

ORA-14010: this physical attribute may not be specified for an index partition
Cause: unexpected option was encountered while parsing physical attributes of an index partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE; only TABLESPACE may be specified for Hash partitions
Action: remove invalid option(s) from the list of physical attributes of an index partition
ORA-14011: names assigned to resulting partitions must be distinct
Cause: Names of partitions resulting from splitting of an existing table or index partition are not distinct
Action: rename resulting partition(s) to ensure that their names are distinct and different from those of any other partition of the table or index
ORA-14012: resulting partition name conflicts with that of an existing partition
Cause: Name of a partition resulting from splitting of an existing table or index partition is identical to that of some other existing partition of that table or index
Action: rename resulting partition(s) to ensure that their names are distinct and different from those of any other partition of the table or index

ORA-14013: duplicate partition name
Cause: Name of a partition of a table or index being created is not unique
Action: rename partition(s) to ensure that their names are unique among partitions of the table or index being created
ORA-14014: maximum number of partitioning columns is 16
Cause: number of columns in a partitioning column list exceeded the legal limit of 16
Action: modify partitioning column list so that it consists of at most 16 columns
ORA-14015: too many partition descriptions
Cause: CREATE TABLE or CREATE INDEX contained too many partition descriptions; maximum number of partitions is 1048575 (1024K-1).
Action: Reduce number of partitions to not exceed 1048575 (1024K -1).

ORA-14016: underlying table of a LOCAL partitioned index must be partitioned
Cause: User attempted to create a LOCAL partitioned index on a non-partitioned table which is illegal. Only GLOBAL indices (partitioned or otherwise) may be created on a non-partitioned table.
Action: Correct the statement and reenter
ORA-14017: partition bound list contains too many elements
Cause: Partition bound list contained more elements than there are partitioning columns
Action: Ensure that the number of elements in partition bound list is equal to the number of partitioning columns of the table or index
ORA-14018: partition bound list contains too few elements
Cause: Partition bound list contained fewer elements than there are partitioning columns
Action: Ensure that the number of elements in partition bound list is equal to the number of partitioning columns of the table or index
ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
Cause: Partition bound list contained an element of invalid type (i.e. not a number, non-empty string, datetime or interval literal, or MAXVALUE)
Action: Ensure that all elements of partition bound list are of valid type

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