{"id":2225,"date":"2016-09-16T09:29:04","date_gmt":"2016-09-16T06:29:04","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2225"},"modified":"2017-02-09T09:32:15","modified_gmt":"2017-02-09T06:32:15","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14000-to-ora-14070","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14000-to-ora-14070\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14000 to ORA-14070"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14000 to ORA-14100<\/strong><\/p>\n

\n
ORA-14000: only one LOCAL clause may be specified<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE INDEX statement contained more than one LOCAL clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify LOCAL option at most once<\/span><\/span><\/p>\n

\n
<\/a> ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE INDEX statement contained a GLOBAL clause and a LOCAL clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify LOCAL or GLOBAL clause, but not both<\/span><\/span><\/p>\n

\n
<\/a> ORA-14002: only one GLOBAL clause may be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE INDEX statement contained more than one GLOBAL clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify GLOBAL option at most once<\/span><\/span><\/p>\n

\n
<\/a> ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE INDEX statement contained a LOCAL clause and a GLOBAL clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify GLOBAL or LOCAL clause, but not both<\/span><\/span><\/p>\n

\n
<\/a> ORA-14004: missing PARTITION keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword PARTITION missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-14005: missing RANGE keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword RANGE missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

<\/p>\n

\n
<\/a> ORA-14006: invalid partition name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a partition name of the form\u00a0identifier<\/i>\u00a0is expected but not present.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0enter an appropriate partition name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14007: missing LESS keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword LESS missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-14008: missing THAN keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword THAN missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-14009: partition bound may not be specified for a LOCAL index partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0while parsing a CREATE INDEX statement to create a LOCAL partitioned index,\u00a0partition-description<\/i>\u00a0of 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove all VALUES LESS THAN clauses from descriptions of LOCAL index partitions<\/span><\/span><\/p>\n

\n
<\/a> ORA-14010: this physical attribute may not be specified for an index partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0unexpected 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove invalid option(s) from the list of physical attributes of an index partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14011: names assigned to resulting partitions must be distinct<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Names of partitions resulting from splitting of an existing table or index partition are not distinct<\/span><\/span><\/p>\n

Action:<\/b>\u00a0rename resulting partition(s) to ensure that their names are distinct and different from those of any other partition of the table or index<\/span><\/span><\/p>\n

\n
<\/a> ORA-14012: resulting partition name conflicts with that of an existing partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Name 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0rename resulting partition(s) to ensure that their names are distinct and different from those of any other partition of the table or index<\/span><\/span><\/p>\n

\n
<\/a> ORA-14013: duplicate partition name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Name of a partition of a table or index being created is not unique<\/span><\/span><\/p>\n

Action:<\/b>\u00a0rename partition(s) to ensure that their names are unique among partitions of the table or index being created<\/span><\/span><\/p>\n

\n
<\/a> ORA-14014: maximum number of partitioning columns is 16<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0number of columns in a partitioning column list exceeded the legal limit of 16<\/span><\/span><\/p>\n

Action:<\/b>\u00a0modify partitioning column list so that it consists of at most 16 columns<\/span><\/span><\/p>\n

\n
<\/a> ORA-14015: too many partition descriptions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE TABLE or CREATE INDEX contained too many partition descriptions; maximum number of partitions is 1048575 (1024K-1).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce number of partitions to not exceed 1048575 (1024K -1).<\/span><\/span><\/p>\n

\n
<\/a> ORA-14016: underlying table of a LOCAL partitioned index must be partitioned<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement and reenter<\/span><\/span><\/p>\n

\n
<\/a> ORA-14017: partition bound list contains too many elements<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partition bound list contained more elements than there are partitioning columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of elements in partition bound list is equal to the number of partitioning columns of the table or index<\/span><\/span><\/p>\n

\n
<\/a> ORA-14018: partition bound list contains too few elements<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partition bound list contained fewer elements than there are partitioning columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of elements in partition bound list is equal to the number of partitioning columns of the table or index<\/span><\/span><\/p>\n

\n
<\/a> ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partition bound list contained an element of invalid type (i.e. not a number, non-empty string, datetime or interval literal, or MAXVALUE)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all elements of partition bound list are of valid type<\/span><\/span><\/p>\n

\n
<\/a> ORA-14020: this physical attribute may not be specified for a table partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0unexpected 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove invalid option(s) from the list of physical attributes of a table partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14021: MAXVALUE must be specified for all columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the VALUES LESS THAN clause for the highest (last) partition of a GLOBAL index, MAXVALUE must be specified for all columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that VALUES LESS THAN clause for the last partition of a GLOBAL index has MAXVALUE specified for all columns<\/span><\/span><\/p>\n

\n
<\/a> ORA-14022: creation of LOCAL partitioned cluster indices is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a LOCAL partitioned cluster index, which is currently illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove LOCAL along with\u00a0partition description<\/i>s, if any, from the CREATE INDEX statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14023: creation of GLOBAL partitioned cluster indices is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a GLOBAL partitioned cluster index, which is currently illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove PARTITION BY RANGE clause along with\u00a0partition description<\/i>s from the CREATE INDEX statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14024: number of partitions of LOCAL index must equal that of the underlying table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to create a LOCAL partitioned index with a number of partitions which is different from that of the underlying table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the CREATE INDEX statement to specify a correct number of partitions<\/span><\/span><\/p>\n

\n
<\/a> ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PARTITION option was encountered while parsing a definition of a materialized view or a materialized view log<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that a definition of a MATERIALIZED VIEW does not include invalid options<\/span><\/span><\/p>\n

\n
<\/a> ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0definition of a table contained both PARTITION and CLUSTER clauses which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of the conflicting clauses<\/span><\/span><\/p>\n

\n
<\/a> ORA-14027: only one PARTITION clause may be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE TABLE statement contained more than one PARTITION clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify PARTITION option at most once<\/span><\/span><\/p>\n

\n
<\/a> ORA-14028: missing AT or VALUES keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword AT or VALUES missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-14029: GLOBAL partitioned index must be prefixed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0partitioning columns of a global partitioned index must form a prefix of the index’ key columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the GLOBAL partitioned index being created is prefixed<\/span><\/span><\/p>\n

\n
<\/a> ORA-14030: non-existent partitioning column in CREATE TABLE statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partitioning column specified in CREATE TABLE statement is not one of columns of the table being created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all columns in the partitioning column list are columns of the table being created.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14031: partitioning column may not be of type LONG or LONG RAW<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partitioning column specified by the user was of type LONG or LONG RAW, which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that no partitioning column is of type LONG or LONG RAW.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14032: partition bound of partition number\u00a0string<\/i>\u00a0is too high<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0High 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that high bound of every partition (except for the last one) collates lower than that of a following partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14036: partition bound value too large for column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Length of partition bound value is longer than that of the corresponding partitioning column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that lengths of high bound values do not exceed those of corresponding partitioning columns<\/span><\/span><\/p>\n

\n
<\/a> ORA-14037: partition bound of partition “string<\/i>” is too high<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0High 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that high bound of every partition (except for the last one) collates lower than that of a following partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14038: GLOBAL partitioned index must be prefixed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to create a GLOBAL non-prefixed partitioned index which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If 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<\/span><\/span><\/p>\n

\n
<\/a> ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to create a UNIQUE partitioned index whose partitioning columns do not form a subset of its key columns which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If 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<\/span><\/span><\/p>\n

\n
<\/a> ORA-14041: partition bound may not be specified for resulting partitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0while parsing an ALTER {TABLE|INDEX} SPLIT PARTITION statement,\u00a0partition-description<\/i>\u00a0of a resulting partition was found to contain VALUES LESS THAN clause which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove VALUES LESS THAN clause from the description(s) of partitions resulting from splitting an existing table or index partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0while 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove VALUES LESS THAN clause from the description of new attributes of the partition being moved, modified, or rebuilt<\/span><\/span><\/p>\n

\n
<\/a> ORA-14043: only one partition may be added<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE ADD PARTITION contained descriptions of more than one partition to be added<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement contains exactly one partition definition and that it does not contain any commas<\/span><\/span><\/p>\n

\n
<\/a> ORA-14044: only one partition may be moved<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE MOVE PARTITION contained descriptions of more than one partition to be moved<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement describes exactly one partition to be moved and that it does not contain any commas<\/span><\/span><\/p>\n

\n
<\/a> ORA-14045: only one partition may be modified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE|INDEX MODIFY PARTITION contained descriptions of more than one partition to be modified<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement describes exactly one partition to be modified and that it does not contain any commas<\/span><\/span><\/p>\n

\n
<\/a> ORA-14046: a partition may be split into exactly two new partitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement describes exactly two partition into which an existing partition is to be split<\/span><\/span><\/p>\n

\n
<\/a> ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE or ALTER INDEX statement attempted to combine a RENAME operation with some other operation which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that RENAME operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement;<\/span><\/span><\/p>\n

\n
<\/a> ORA-14048: a partition maintenance operation may not be combined with other operations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure 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<\/span><\/span><\/p>\n

\n
<\/a> ORA-14049: invalid ALTER TABLE MODIFY PARTITION option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14050: invalid ALTER INDEX MODIFY PARTITION option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than INITRANS, MAXTRANS, STORAGE, or DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY PARTITION statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14051: invalid ALTER MATERIALIZED VIEW option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or BACKUP was specified in an ALTER MATERIALIZED VIEW statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14052: partition-extended table name syntax is disallowed in this context<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to use partition-extended table name syntax in illegal context (i.e. not in FROM-clause or INSERT, DELETE, or UPDATE statement)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Avoid use of partition-extended table name in contexts other those mentioned above.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14053: illegal attempt to modify\u00a0string<\/i>\u00a0in\u00a0string<\/i>\u00a0statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Certain 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that ALTER statement specifies new values only for attributes which may be changed once an object has been created<\/span><\/span><\/p>\n

\n
<\/a> ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Name of the partition to be truncated may be followed by DROP STORAGE or REUSE STORAGE<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that no options besides DROP STORAGE or REUSE STORAGE are specified with ALTER TABLE TRUNCATE PARTITION<\/span><\/span><\/p>\n

\n
<\/a> ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow\u00a0index name<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER INDEX statement contained REBUILD keyword following some index attributes (e.g. INITRANS.)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that keyword REBUILD immediately follows the name of the index being altered<\/span><\/span><\/p>\n

\n
<\/a> ORA-14056: partition number\u00a0string<\/i>: sum of PCTUSED and PCTFREE may not exceed 100<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100<\/span><\/span><\/p>\n

\n
<\/a> ORA-14057: partition “string<\/i>“: sum of PCTUSED and PCTFREE may not exceed 100<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100<\/span><\/span><\/p>\n

\n
<\/a> ORA-14058: partition number\u00a0string<\/i>: INITRANS value must be less than MAXTRANS value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Value 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0ensure 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<\/span><\/span><\/p>\n

\n
<\/a> ORA-14059: partition “string<\/i>“: INITRANS value must be less than MAXTRANS value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Value 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0ensure 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<\/span><\/span><\/p>\n

\n
<\/a> ORA-14060: data type or length of a table partitioning column may not be changed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Avoid modifying data type and\/or length of table partitioning column(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14061: data type or length of an index partitioning column may not be changed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Avoid modifying data type and\/or length of index partitioning column(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14062: one or more of table’s partitions reside in a read-only tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Avoid performing aformentioned operations on a partitioned table one or more partitions of which reside in read-only tablespaces<\/span><\/span><\/p>\n

\n
<\/a> ORA-14063: Unusable index exists on unique\/primary constraint key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the existing index or rebuild it using ALTER INDEX REBUILD<\/span><\/span><\/p>\n

\n
<\/a> ORA-14064: Index with Unusable partition exists on unique\/primary constraint key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the existing index or rebuild unusable partitions it using ALTER INDEX REBUILD PARTITION<\/span><\/span><\/p>\n

\n
<\/a> ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified ALLOCATE STORAGE clause in ALTER TABLE statement issued against a partitioned table which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14066: illegal option for a non-partitioned index-organized table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the illegal option(s) from the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14067: duplicate TABLESPACE_NUMBER specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0TABLESPACE_NUMBER clause was specified more than once for an table, index or an index partition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the code generating text of CREATE INDEX statement sent to the slaves<\/span><\/span><\/p>\n

\n
<\/a> ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Both TABLESPACE and TABLESPACE_NUMBER clauses were specified for a table, index or an index partition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the code generating text of CREATE INDEX statement sent to the slaves<\/span><\/span><\/p>\n

\n
<\/a> ORA-14069: invalid TABLESPACE_NUMBER value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE_NUMBER value is not an integer between 0 and 0x7FFFFFFF<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the code generating text of CREATE INDEX statement sent to the slaves<\/span><\/span><\/p>\n

\n
<\/a> ORA-14070: option may be specified only for partitioned indices or with REBUILD<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove illegal option(s).<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14000 to ORA-14100 ORA-14000: only one LOCAL clause may be specified Cause:\u00a0CREATE INDEX statement contained more than one LOCAL clause Action:\u00a0Specify LOCAL option at most once ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause Cause:\u00a0CREATE INDEX statement contained a GLOBAL clause and a LOCAL clause Action:\u00a0Specify…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2225","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-zT","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2225"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2225\/revisions"}],"predecessor-version":[{"id":2229,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2225\/revisions\/2229"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2225"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}