Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14000 to ORA-14100
- ORA-14000: only one LOCAL clause may be specified
Cause: CREATE INDEX statement contained more than one LOCAL clause
Action: Specify LOCAL option at most once
Cause: CREATE INDEX statement contained a GLOBAL clause and a LOCAL clause
Action: Specify LOCAL or GLOBAL clause, but not both
Cause: CREATE INDEX statement contained more than one GLOBAL clause
Action: Specify GLOBAL option at most once
Cause: CREATE INDEX statement contained a LOCAL clause and a GLOBAL clause
Action: Specify GLOBAL or LOCAL clause, but not both
Cause: keyword PARTITION missing
Action: supply missing keyword
Cause: keyword RANGE missing
Action: supply missing keyword
Cause: a partition name of the form identifier is expected but not present.
Action: enter an appropriate partition name.
Cause: keyword LESS missing
Action: supply missing keyword
Cause: keyword THAN missing
Action: supply missing keyword
Cause: while parsing a CREATE INDEX statement to create a LOCAL partitioned index, partition-description of one of partitions was found to contain VALUES LESS THAN clause which is illegal since a LOCAL index inherits partition bounds from its base table
Action: remove all VALUES LESS THAN clauses from descriptions of LOCAL index partitions
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
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
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
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
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
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).
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
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
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
Cause: unexpected option was encountered while parsing physical attributes of a table partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, and PCTUSED; only TABLESPACE may be specified for Hash partitions
Action: remove invalid option(s) from the list of physical attributes of a table partition
Cause: In the VALUES LESS THAN clause for the highest (last) partition of a GLOBAL index, MAXVALUE must be specified for all columns
Action: Ensure that VALUES LESS THAN clause for the last partition of a GLOBAL index has MAXVALUE specified for all columns
Cause: An attempt was made to create a LOCAL partitioned cluster index, which is currently illegal
Action: Remove LOCAL along with partition descriptions, if any, from the CREATE INDEX statement.
Cause: An attempt was made to create a GLOBAL partitioned cluster index, which is currently illegal
Action: Remove PARTITION BY RANGE clause along with partition descriptions from the CREATE INDEX statement.
Cause: User attempted to create a LOCAL partitioned index with a number of partitions which is different from that of the underlying table.
Action: Correct the CREATE INDEX statement to specify a correct number of partitions
Cause: PARTITION option was encountered while parsing a definition of a materialized view or a materialized view log
Action: Ensure that a definition of a MATERIALIZED VIEW does not include invalid options
Cause: definition of a table contained both PARTITION and CLUSTER clauses which is illegal
Action: Remove one of the conflicting clauses
Cause: CREATE TABLE statement contained more than one PARTITION clause
Action: Specify PARTITION option at most once
Cause: keyword AT or VALUES missing
Action: supply missing keyword
Cause: partitioning columns of a global partitioned index must form a prefix of the index’ key columns
Action: Ensure that the GLOBAL partitioned index being created is prefixed
Cause: Partitioning column specified in CREATE TABLE statement is not one of columns of the table being created.
Action: Ensure that all columns in the partitioning column list are columns of the table being created.
Cause: Partitioning column specified by the user was of type LONG or LONG RAW, which is illegal.
Action: Ensure that no partitioning column is of type LONG or LONG RAW.
Cause: High bound of the partition whose number (partitions are numbered starting with 1) is displayed in this message did not collate lower than that of the following partition, which is illegal.
Action: Ensure that high bound of every partition (except for the last one) collates lower than that of a following partition.
Cause: Length of partition bound value is longer than that of the corresponding partitioning column.
Action: Ensure that lengths of high bound values do not exceed those of corresponding partitioning columns
Cause: High bound of the partition whose name (explicitly specified by the user) is displayed in this message did not collate lower than that of the following partition, which is illegal.
Action: Ensure that high bound of every partition (except for the last one) collates lower than that of a following partition.
Cause: User attempted to create a GLOBAL non-prefixed partitioned index which is illegal
Action: If the user, indeed, desired to create a non-prefixed index, it must be created as LOCAL; otherwise, correct the list of key and/or partitioning columns to ensure that the index is prefixed
Cause: User attempted to create a UNIQUE partitioned index whose partitioning columns do not form a subset of its key columns which is illegal
Action: If the user, indeed, desired to create an index whose partitioning columns do not form a subset of its key columns, it must be created as non-UNIQUE; otherwise, correct the list of key and/or partitioning columns to ensure that the index’ partitioning columns form a subset of its key columns
Cause: while parsing an ALTER {TABLE|INDEX} SPLIT PARTITION statement, partition-description of a resulting partition was found to contain VALUES LESS THAN clause which is illegal
Action: remove VALUES LESS THAN clause from the description(s) of partitions resulting from splitting an existing table or index partition
Cause: while parsing an ALTER {TABLE|INDEX} MODIFY PARTITION, ALTER TABLE MOVE PARTITION, or ALTER INDEX REBUILD PARTITION statement, description of new physical attributes of the partition being moved, modified, or rebuilt was found to contain VALUES LESS THAN clause which is illegal
Action: remove VALUES LESS THAN clause from the description of new attributes of the partition being moved, modified, or rebuilt
Cause: ALTER TABLE ADD PARTITION contained descriptions of more than one partition to be added
Action: Ensure that the statement contains exactly one partition definition and that it does not contain any commas
Cause: ALTER TABLE MOVE PARTITION contained descriptions of more than one partition to be moved
Action: Ensure that the statement describes exactly one partition to be moved and that it does not contain any commas
Cause: ALTER TABLE|INDEX MODIFY PARTITION contained descriptions of more than one partition to be modified
Action: Ensure that the statement describes exactly one partition to be modified and that it does not contain any commas
Cause: ALTER TABLE|INDEX SPLIT PARTITION did not contain descriptions of exactly two new partitions into which an existing table or index partition was to be split
Action: Ensure that the statement describes exactly two partition into which an existing partition is to be split
Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a RENAME operation with some other operation which is illegal
Action: Ensure that RENAME operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement;
Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a partition maintenance operation (e.g. MOVE PARTITION) with some other operation (e.g. ADD PARTITION or PCTFREE which is illegal
Action: Ensure that a partition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with partitions, default attributes of partitioned tables/indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, BACKUP, ALLOCATE EXTENT, or DEALLOCATE UNUSED was specified in an ALTER TABLE MODIFY PARTITION statement for a Range or Composite Range partition.
Action: Specify only legal options.
Cause: An option other than INITRANS, MAXTRANS, STORAGE, or DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY PARTITION statement.
Action: Specify only legal options.
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or BACKUP was specified in an ALTER MATERIALIZED VIEW statement.
Action: Specify only legal options.
Cause: User attempted to use partition-extended table name syntax in illegal context (i.e. not in FROM-clause or INSERT, DELETE, or UPDATE statement)
Action: Avoid use of partition-extended table name in contexts other those mentioned above.
Cause: Certain attributes of objects (e.g. tables) may be specified at creation time, but may not be modified using ALTER statement. Unfortunately, user specified one of such attributes.
Action: Ensure that ALTER statement specifies new values only for attributes which may be changed once an object has been created
Cause: Name of the partition to be truncated may be followed by DROP STORAGE or REUSE STORAGE
Action: Ensure that no options besides DROP STORAGE or REUSE STORAGE are specified with ALTER TABLE TRUNCATE PARTITION
Cause: ALTER INDEX statement contained REBUILD keyword following some index attributes (e.g. INITRANS.)
Action: Ensure that keyword REBUILD immediately follows the name of the index being altered
Cause: the sum of PCTUSED and PCTFREE for a partition whose number (partitions are numbered starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this partition were not specified explicitly, default values for the partitioned table or index would be used. If, in turn, default PCTUSED and/or PCTFREE values for the partitioned table or index were not specified, system defaults would be used.
Action: ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100
Cause: the sum of PCTUSED and PCTFREE for a partition whose name (explicitly specified by the user) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this partition were not specified explicitly, default values for the partitioned table or index would be used. If, in turn, default PCTUSED and/or PCTFREE values for the partitioned table or index were not specified, system defaults would be used.
Action: ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100
Cause: Value of INITRANS was found to be greater than that of MAXTRANS for a partition whose number (partitions are numbered starting with 1) is displayed in this message. Note that if INITRANS and/or MAXTRANS values for this partition were not specified explicitly, default values for the partitioned table or index would be used. If, in turn, default INITRANS and/or MAXTRANS values for the partitioned table or index were not specified, system defaults would be used.
Action: ensure that value of INITRANS (whether specified explcitly or derived from the default value for the partitioned table or index) is no greater than that of MAXTRANS
Cause: Value of INITRANS was found to be greater than that of MAXTRANS for a partition whose name (explicitly specified by the user) is displayed in this message. Note that if INITRANS and/or MAXTRANS values for this partition were not specified explicitly, default values for the partitioned table or index would be used. If, in turn, default INITRANS and/or MAXTRANS values for the partitioned table or index were not specified, system defaults would be used.
Action: ensure that value of INITRANS (whether specified explcitly or derived from the default value for the partitioned table or index) is no greater than that of MAXTRANS
Cause: User issued ALTER TABLE statement attempting to modify data type and/or length of a column used to partition the table named in ALTER TABLE statement, which is illegal
Action: Avoid modifying data type and/or length of table partitioning column(s)
Cause: User issued ALTER TABLE statement attempting to modify data type and/or length of a column used to partition some index defined on the table named in ALTER TABLE statement, which is illegal
Action: Avoid modifying data type and/or length of index partitioning column(s)
Cause: User issued ALTER TABLE statement attempting to modify an existing VARCHAR2 (or VARCHAR) column to be of type CHAR (or CHARACTER), increase length of an existing CHAR (or CHARACTER) column, or add a column with user-specified default for a table one or more partitions of which reside in read-only tablespaces, which is illegal
Action: Avoid performing aformentioned operations on a partitioned table one or more partitions of which reside in read-only tablespaces
Cause: User attempted to add or enable a primary key/unique constraint on column(s) of a table on which there exists an index marked Index Unusable.
Action: Drop the existing index or rebuild it using ALTER INDEX REBUILD
Cause: User attempted to add or enable a primary key/unique constraint on column(s) of a table on which there exists an index one or more partitions of which are marked Index Unusable.
Action: Drop the existing index or rebuild unusable partitions it using ALTER INDEX REBUILD PARTITION
Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE statement issued against a partitioned table which is illegal.
Action: Remove the illegal option. If it is desired to add storage to individual partitions, ALLOCATE STORAGE clause may be specified with ALTER TABLE MODIFY PARTITION statement.
Cause: An attempt was made to issue a CREATE or ALTER TABLE command on a non-partitioned IOT, but the command contains an option that is legal only for partitioned index-organized tables. Such options are: ENABLE ROW MOVEMENT and DISABLE ROW MOVEMENT.
Action: Remove the illegal option(s) from the command.
Cause: TABLESPACE_NUMBER clause was specified more than once for an table, index or an index partition
Action: Correct the code generating text of CREATE INDEX statement sent to the slaves
Cause: Both TABLESPACE and TABLESPACE_NUMBER clauses were specified for a table, index or an index partition
Action: Correct the code generating text of CREATE INDEX statement sent to the slaves
Cause: The TABLESPACE_NUMBER value is not an integer between 0 and 0x7FFFFFFF
Action: Correct the code generating text of CREATE INDEX statement sent to the slaves
Cause: User issued ALTER INDEX statament containing an option which is legal only for partitioned indices or in conjunction with REBUILD against a non-partitioned index. Such options are: PCTFREE, TABLESPACE, [NO]PARALLEL and INITIAL, FREELISTS, and FREELIST GROUPS inside STORAGE clause
Action: Remove illegal option(s).