ORA-14103: LOGGING or NOLOGGING may not be combined with RECOVERABLE or UNRECOVERABLE

ORA-14103: LOGGING or NOLOGGING may not be combined with RECOVERABLE or UNRECOVERABLE

Cause: A statement contained both (NO(LOGGING and (UN(RECOVERABLE clauses which is disallowed.

Action: Remove one of the offending clauses. (UN(RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.

ORA-14102: only one LOGGING or NOLOGGING clause may be specified

ORA-14102: only one LOGGING or NOLOGGING clause may be specified

Cause: LOGGING was specified more than once, NOLOGGING was specified more than once, or both LOGGING and NOLOGGING were specified.

Action: Remove all but one of the LOGGING or NOLOGGING clauses and reissue the statement.

ORA-14101: partition extended table name cannot refer to a synonym

ORA-14101: partition extended table name cannot refer to a synonym

Cause: User attempted to use partition-extended table name syntax in conjunction with synonym name which is illegal

Action: Correct the statement and reenter

ORA-14100: partition extended table name cannot refer to a remote object

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

ORA-14099: all rows in table do not qualify for specified partition

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-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

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-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

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-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

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-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

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-14094: invalid ALTER TABLE EXCHANGE PARTITION option

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-14086: a partitioned index may not be rebuilt as a whole

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-14085: partitioned table cannot have column with LONG datatype

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-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index

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-14083: cannot drop the only partition of a partitioned table

ORA-14083: cannot drop the only partition of a partitioned table

Cause: A drop partition command is being executed when there is only one partition in the table

Action: Ensure that there is at least one partition. Drop table to remove all partitions

ORA-14082: new partition name must differ from that of any other partition of the object

ORA-14082: new partition name must differ from that of any other partition of the object

Cause: User entered ALTER TABLE or INDEX RENAME PARTITION specifying lamp;lt;lamp;nbsp;new-partition-namelamp;gt; which is identical to the name of some existing partition of the object

Action: Ensure that the new partition name is different from the name of any (including the one being renamed) existing partition of a given table or index

ORA-14081: new partition name must differ from the old partition name

ORA-14081: new partition name must differ from the old partition name

Cause: User entered ALTER TABLE or INDEX RENAME PARTITION specifying lamp;lt;lamp;nbsp;new-partition-namelamp;gt; which is identical to the name of the partition being renamed

Action: Ensure that the new partition name is different from the name of any (including the one being renamed) existing partition of a given table or index

ORA-14080: partition cannot be split along the specified high bound

ORA-14080: partition cannot be split along the specified high bound

Cause: User attempted to split a partition along a bound which either collates higher than that of the partition to be split or lower than that of a partition immediately preceding the one to be split

Action: Ensure that the bound along which a partition is to be split collates lower than that of the partition to be split and higher that that of a partition immediately preceding the one to be split

ORA-14079: illegal option for a partition marked Index Unusable

ORA-14079: illegal option for a partition marked Index Unusable

Cause: ALTER INDEX MODIFY PARTITION statement against an index partition marked Index Unusable contained STORAGE and or or DEALLOCATE SPACE clauses which is illegal

Action: Ensure that only valid optins are specified

ORA-14078: you may not drop the highest partition of a GLOBAL index

ORA-14078: you may not drop the highest partition of a GLOBAL index

Cause: User attempted to drop highest partition of a GLOBAL index, which is illegal.

Action: Ensure that the partition specified in ALTER INDEX DROP PARTITION statement is not the highest partition of the index.

ORA-14076: submitted alter index partition or subpartition operation is not valid for local partitioned index

ORA-14076: submitted alter index partition or subpartition operation is not valid for local partitioned index

Cause: User attempted to either drop, split, add or coalesce a partition or a subpartition of a local index which is illegal.

Action: Ensure that the index named in such statement is a global partitioned index.

ORA-14075: partition maintenance operations may only be performed on partitioned indices

ORA-14075: partition maintenance operations may only be performed on partitioned indices

Cause: Index named in ALTER INDEX partition maintenance operation is not partitioned, making a partition maintenance operation, at best, meaningless

Action: Ensure that the index named in ALTER INDEX statement specifying a partition maintenance operation is, indeed, partitioned

ORA-14074: partition bound must collate higher than that of the last partition

ORA-14074: partition bound must collate higher than that of the last partition

Cause: Partition bound specified in ALTER TABLE ADD PARTITION statement did not collate higher than that of the table s last partition, which is illegal.

Action: Ensure that the partition bound of the partition to be added collates higher than that of the table s last partition.

ORA-14073: bootstrap table or cluster may not be truncated

ORA-14073: bootstrap table or cluster may not be truncated

Cause: User attempted to truncate a bootstrap table or cluster which is illegal

Action: Ensure that the table (or cluster) being truncated is not a bootstrap table (or cluster)

ORA-14072: fixed table may not be truncated

ORA-14072: fixed table may not be truncated

Cause: User attempted to truncate a fixed table which is illegal.

Action: Ensure that the table being truncated is not a fixed table.

ORA-14071: invalid option for an index used to enforce a constraint

ORA-14071: invalid option for an index used to enforce a constraint

Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified for an index used to enforce a constraint.

Action: Choose one of the valid index options.

ORA-14070: option may be specified only for partitioned indices or with REBUILD

ORA-14070: option may be specified only for partitioned indices or with REBUILD

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).

ORA-14069: invalid TABLESPACE_NUMBER value

ORA-14069: invalid TABLESPACE_NUMBER value

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

ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

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

ORA-14067: duplicate TABLESPACE_NUMBER specification

ORA-14067: duplicate TABLESPACE_NUMBER specification

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

ORA-14066: illegal option for a non-partitioned index-organized table

ORA-14066: illegal option for a non-partitioned index-organized table

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.

ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

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.

ORA-14064: Index with Unusable partition exists on unique or primary constraint key

ORA-14064: Index with Unusable partition exists on unique or primary constraint key

Cause: User attempted to add or enable a primary key or 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

ORA-14063: Unusable index exists on unique or primary constraint key

ORA-14063: Unusable index exists on unique or primary constraint key

Cause: User attempted to add or enable a primary key or 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

ORA-14062: one or more of table s partitions reside in a read-only tablespace

ORA-14062: one or more of table s partitions reside in a read-only tablespace

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

ORA-14061: data type or length of an index partitioning column may not be changed

ORA-14061: data type or length of an index partitioning column may not be changed

Cause: User issued ALTER TABLE statement attempting to modify data type and or 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 or length of index partitioning column(s)

ORA-14060: data type or length of a table partitioning column may not be changed

ORA-14060: data type or length of a table partitioning column may not be changed

Cause: User issued ALTER TABLE statement attempting to modify data type and or 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 or length of table partitioning column(s)

ORA-14059: partition string : INITRANS value must be less than MAXTRANS value

ORA-14059: partition string : INITRANS value must be less than MAXTRANS value

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 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 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

ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value

ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value

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 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 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

ORA-14057: partition string : sum of PCTUSED and PCTFREE may not exceed 100

ORA-14057: partition string : sum of PCTUSED and PCTFREE may 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 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 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

ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

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 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 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

ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow lamp;lt;lamp;nbsp;index namelamp;gt;

ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow lamp;lt;lamp;nbsp;index namelamp;gt;

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

ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

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

ORA-14053: illegal attempt to modify string in string statement

ORA-14053: illegal attempt to modify string in string statement

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

ORA-14052: partition-extended table name syntax is disallowed in this context

ORA-14052: partition-extended table name syntax is disallowed in this context

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.

ORA-14051: invalid ALTER MATERIALIZED VIEW option

ORA-14051: invalid ALTER MATERIALIZED VIEW option

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.

ORA-14050: invalid ALTER INDEX MODIFY PARTITION option

ORA-14050: invalid ALTER INDEX MODIFY PARTITION option

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.

ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

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.

ORA-14048: a partition maintenance operation may not be combined with other operations

ORA-14048: a partition maintenance operation may not be combined with other operations

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 or indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

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;

ORA-14046: a partition may be split into exactly two new partitions

ORA-14046: a partition may be split into exactly two new partitions

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

ORA-14045: only one partition may be modified

ORA-14045: only one partition may be modified

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

ORA-14044: only one partition may be moved

ORA-14044: only one partition may be moved

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

ORA-14043: only one partition may be added

ORA-14043: only one partition may be added

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

ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

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

ORA-14041: partition bound may not be specified for resulting partitions

ORA-14041: partition bound may not be specified for resulting partitions

Cause: while parsing an ALTER {TABLE|INDEX} SPLIT PARTITION statement, lamp;lt;lamp;nbsp;partition-descriptionlamp;gt; 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

ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

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 or partitioning columns to ensure that the index partitioning columns form a subset of its key columns

ORA-14038: GLOBAL partitioned index must be prefixed

ORA-14038: GLOBAL partitioned index must be prefixed

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 or partitioning columns to ensure that the index is prefixed

ORA-14037: partition bound of partition string is too high

ORA-14037: partition bound of partition string is too high

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.

ORA-14036: partition bound value too large for column

ORA-14036: partition bound value too large for column

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

ORA-14032: partition bound of partition number string is too high

ORA-14032: partition bound of partition number string is too high

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.