{"id":2230,"date":"2016-09-16T10:03:25","date_gmt":"2016-09-16T07:03:25","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2230"},"modified":"2017-02-09T10:05:10","modified_gmt":"2017-02-09T07:05:10","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14070-to-ora-14300","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14070-to-ora-14300\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14070 to ORA-14300"},"content":{"rendered":"

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

\n
ORA-14170: cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request was made to generate default partition description(s) (possibly via PARTITIONS\u00a0number-of-partitions<\/i>) while at the same time specified <(sub)partition-description> clause which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of offending clauses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14171: cannot specify\u00a0subpartition-description<\/i>\u00a0clause in CREATE|ALTER TABLE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User requested to generate default subpartition description(s) (possibly via SUBPARTITIONS) while at the same time specified\u00a0subpartition-description<\/i>\u00a0clause which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of offending clauses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Name of the table to be EXCHANGED has to be followed by [{INCLUDING|EXCLUDING} INDEX][{WITH|WITHOUT} VALIDATION]<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/span><\/p>\n

\n
<\/a> ORA-14173: illegal subpartition-extended table name syntax<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Subpartition to be accessed may only be specified using its name. User attempted to use a subpartition number or a bind variable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify statement to refer to a subpartition using its name<\/span><\/span><\/p>\n

\n
<\/a> ORA-14174: only a\u00a0parallel clause<\/i>\u00a0may follow COALESCE PARTITION|SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE COALESCE PARTITION|SUBPARTITION may be followed by an optional\u00a0parallel clause<\/i>. No partition\/subpartition attributes may be specified<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that no partition\/subpartition attribute was specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14175: a subpartition 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 subpartition maintenance operation (e.g. MOVE SUBPARTITION) with some other operation (e.g. MODIFY PARTITION ADD SUBPARTITION or PCTFREE) which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that a subpartition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with subpartitions, default attributes of partitioned tables\/indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will<\/span><\/span>
\n<\/p>\n

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

Cause:<\/b>\u00a0An invalid option was encountered while parsing physical attributes of a partition of an object partitioned using the HASH method. The TABLESPACE option is the only valid option for such partitions.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0STORE-IN (Tablespace list) clause was used while creating a local index on a range\/list\/composite range list partitioned table<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use the STORE_IN (Tablespace list) clause while creating a local index on range\/list\/composite range list partitioned table<\/span><\/span><\/p>\n

\n
<\/a> ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0STORE IN (DEFAULT) is valid only for local indexes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0a) Specify a tablespace list in place of DEFAULT, or b) Remove STORE IN clause and specify tablespaces individually for each index partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14179: An unsupported partitioning method was specified in this context.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an unsupported partitioning method in this context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the invalid option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to specify TABLESPACE DEFAULT for a partition of a Range\/System\/Hash partitioned LOCAL index object, which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Replace TABLESPACE DEFAULT with TABLESPACE <ts_name> or remove it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14185: incorrect physical attribute specified for this index partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unexpected option was encountered while parsing physical attributes of a local index partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, PCTUSED, LOGGING and TABLESPACE; but only TABLESPACE may be specified for Hash partitions STORE IN () is also disallowed for all but Hash, Interval, Autolist, Composite Range Hash, Composite Interval, Composite Autolist partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the invalid options from the list of physical attributes of an index partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14186: number of sub-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 sub-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 sub-partitions<\/span><\/span><\/p>\n

\n
<\/a> ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to create a LOCAL partitioned index that is not equi-partitioned with the underlying table. The partitioning types are mismatched.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the CREATE INDEX statement to ensure that the index partitionining method is consistent with that of the base table<\/span><\/span><\/p>\n

\n
<\/a> ORA-14188: sub-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 sub-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 subpartitioning 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 subpartitioning columns to ensure that the index’ subpartitioning columns form a subset of its key columns<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0unexpected option was encountered while parsing physical attributes of an index subpartition; TABLESPACE is the only valid option<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove invalid option(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14190: only one ENABLE\/DISABLE ROW MOVEMENT clause can be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of three possible actions caused the error: 1) ENABLE ROW MOVEMENT was specified more than once. 2) DISABLE ROW MOVEMENT was specified more than once. 3) Both ENABLE ROW MOVEMENT and DISABLE ROW MOVEMENT were specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all but one of the ENABLE ROW MOVEMENT or DISABLE ROW MOVEMENT clauses; then, reissue the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14191: ALLOCATE EXTENT may not be specified for composite partitioned object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the illegal option. If you want to add storage to individual [sub]partitions,the ALLOCATE EXTENT clause may be specified with ALTER TABLE OR INDEX MODIFY [SUB]PARTITION statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14192: cannot modify physical index attributes of a Hash index partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to modify one of INITRANS\/MAXTRANS\/LOGGING\/STORAGE clause for an index partition of a Hash partitioned index<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the physical attributes one is trying to modify<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0An option other than UNUSABLE, ALLOCATE EXTENT, DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY SUBPARTITION statement.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14194: only one subpartition may be rebuilt<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER INDEX REBUILD SUBPARTITION contained descriptions of more than one subpartition to be rebuilt<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified ALLOCATE STORAGE clause in ALTER TABLE\/ALTER INDEX statement issued against a range-partitioned index 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\/INDEX MODIFY PARTITION statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14196: Specified index cannot be used to enforce the constraint.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The index specified to enforce the constraint is unsuitable for the purpose.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a suitable index or allow one to be built automatically.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14201: specified subpartition bound is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Length of a linear key representation of a high bound of a table subpartition being added or along which an existing table or index subpartition is being split exceeded the legal limit (4K).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0High bound of the specified subpartition displayed in this message did not collate lower than that of the subsequent subpartition.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14203: subpartition bound of subpartition “string<\/i>” is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Length of linear key representation of a high bound of the specified subpartition displayed in this message exceeded the legal limit (4K).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0High bound of the specified subpartition displayed in this message did not collate lower than that of the subsequent subpartition.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14205: subpartition bound of subpartition number\u00a0string<\/i>\u00a0is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Length of linear key representation of a high bound of the specified subpartition displayed in this message exceeded the legal limit (4K).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14206: table is not subpartitioned by List or Range methods<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition maintenance operation such as ALTER TABLE DROP|SPLIT|MERGE SUBPARTITION can only be performed on List or Range subpartitioned objects<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue the command only against a List or Range subpartitioned object.<\/span><\/span><\/p>\n

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

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

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

\n
<\/a> ORA-14208: lower-bound subpartition must be specified first<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A higher-bound subpartition was specified before the lower-bound subpartition in ALTER TABLE MERGE SUBPARTITIONS statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify lower-bound subpartition first and then higher-bound subpartition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14209: subpartitions being merged are not adjacent<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to merge two subpartitions that are not adjacent to each other.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify two subpartitions that are adjacent<\/span><\/span><\/p>\n

\n
<\/a> ORA-14210: cannot reuse lower-bound subpartition as resulting subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to reuse the lower-bound subpartition of the subpartitions being merged.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify new resulting subpartition name or reuse the higher-bound subpartition only<\/span><\/span><\/p>\n

\n
<\/a> ORA-14211: subpartition bound must collate higher than that of the last subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Subpartition bound specified in ALTER TABLE MODIFY PARTITION ADD SUBPARTITION statement did not collate higher than that of the partition’s last subpartition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the subpartition bound of the subpartition to be added collates higher than that of the table partition’s last subpartition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14212: subpartition cannot be split along the specified high bound<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to split a subpartition along a bound which either collates higher than that of the subpartition to be split or lower than that of a subpartition immediately preceding the one to be split<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the bound along which a subpartition is to be split collates lower than that of the subpartition to be split and higher than that of a subpartition immediately preceding the one to be split<\/span><\/span><\/p>\n

\n
<\/a> ORA-14213: VALUES LESS THAN or AT clause cannot be used for List subpartitioned tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0VALUES LESS THAN or AT clause was used for List subpartitioned tables<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use VALUES (value list<\/i>) clause for List subpartitioned tables<\/span><\/span><\/p>\n

\n
<\/a> ORA-14214: VALUES (value list<\/i>) cannot be used for Range subpartitioned tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0VALUES (value list<\/i>) clause was used for Range subpartitioned tables<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use VALUES LESS THAN or AT clause with Range subpartitioned tables<\/span><\/span><\/p>\n

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

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

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

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

Cause:<\/b>\u00a0Subpartition bound list contained fewer elements than there are subpartitioning 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-14217: VALUES (value list<\/i>) clause expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0VALUES (value list<\/i>) clause was not specified for the list subpartition being added<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a VALUES (value list<\/i>) clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-14218: Invalid operation for object without a segment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object (table or index or lob) did not have a segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create segments for the object with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14220: Invalid operation for object without a segment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to modify storage or allocate an extent for an object (table or LOB or index) without a segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create segments for the object with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14221: Dictionary managed tablespace cannot be used for this operation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to create an index or add a LOB column in a dictionary managed tablespace to a table without a segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a locally managed tablespace OR create segments for the table with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14223: Deferred segment creation is not supported for this table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SEGMENT CREATION DEFERRED clause was specified in the CREATE TABLE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the SEGMENT CREATION DEFERRED clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14224: Deferred segment creation is not supported for this schema<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SEGMENT CREATION DEFERRED clause was specified in the CREATE TABLE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the SEGMENT CREATION DEFERRED clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14225: The INDEXING clause is not supported for this table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INDEXING clause was specified for an unsupported table type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the INDEXING clause from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14226: unique index may not be PARTIAL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0INDEXING PARTIAL was specified during creation or modification of a unique index.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the INDEXING PARTIAL clause from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14227: INDEXING may be specified only when the underlying table is partitioned<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0INDEXING FULL or INDEXING PARTIAL was specified during CREATE INDEX or ALTER INDEX when the base table was not partitioned.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the INDEXING clause from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14228: INDEXING may not be specified for this index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0INDEXING FULL or INDEXING PARTIAL was specified during CREATE INDEX or ALTER INDEX for an unsupported index type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the INDEXING clause from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14229: cannot modify the indexing attribute of a composite partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform ALTER TABLE MODIFY PARTITION INDEXING [ON|OFF] on a composite table partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Run ALTER TABLE MODIFY SUBPARTITION INDEXING [ON|OFF] on each subpartition individually.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14251: Specified subpartition does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Subpartition not found for the object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with correct subpartition name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Only ALLOCATE EXTENT and DEALLOCATE UNUSED may be specified in ALTER TABLE MODIFY PARTITION for a Hash partition.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14253: table is not partitioned by composite partition method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the following occurred: – The table in a subpartition maintenance operation (ALTER TABLE [EXCHANGE | MODIFY | MOVE | TRUNCATE] SUBPARTITION or ALTER TABLE MODIFY PARTITION [ADD | COALESCE] SUBPARTITION) was not partitioned by the composite partition method. – The table in the MODIFY DEFAULT ATTRIBUTES FOR PARTITION operation was partitioned by a method other than the composite method. – The table in the ALTER TABLE MODIFY SUBPARTITION [UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES] statement was not partitioned by the composite partition method which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the table is partitioned by composite partition method.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified ALLOCATE STORAGE clause in ALTER TABLE statement issued against a Range or Composite Range 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\/subpartitions, ALLOCATE STORAGE clause may be specified with ALTER TABLE MODIFY PARTITION\/SUBPARTITION statement. If it is desired to add storage to all subpartitions of a Composite partition, ALLOCATE STORAGE clause may be specified with ALTER TABLE MODIFY PARTITION.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14255: table is not partitioned by range, list, composite range, or composite list method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table was not partitioned by the range, list, composite range, or composite list method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The ALTER TABLE [SPLIT | DROP] PARTITION or ALTER TABLE MERGE PARTITIONS command is only valid for a table partitioned by range, list, composite range, or composite list methods. Ensure that the table is partitioned appropriately.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14256: invalid resulting partition description(s)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified STORE-IN clause, SUBPARTITIONS clause, and\/or\u00a0subpartition-description<\/i>\u00a0clause in partition description(s) in ALTER TABLE SPLIT PARTITION or ALTER TABLE MERGE PARTITIONS statement but the table in the maintenance operation is not a Composite Range partitioned table which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove invalid clause(s), or ensure that the table is partitioned by Composite Range method<\/span><\/span><\/p>\n

\n
<\/a> ORA-14257: cannot move a partition which is a composite partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to move a partition that was a composite partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Move the subpartitions one-by-one to move the composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14258: invalid partition description<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified STORE-IN clause, SUBPARTITIONS clause, and\/or\u00a0subpartition-description<\/i>\u00a0clause in ALTER TABLE ADD PARTITION statement but the table in the maintenance operation is not a Composite Range\/Hash partitioned table which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove invalid clause(s), or ensure that the table is partitioned by Composite Range\/Hash method<\/span><\/span><\/p>\n

\n
<\/a> ORA-14259: table is not partitioned by Hash method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE COALESCE PARTITION is only valid for table partitioned by Hash method<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify valid ALTER TABLE option for the table, or ensure that the table is partitioned by Hash method<\/span><\/span><\/p>\n

\n
<\/a> ORA-14260: incorrect physical attribute specified for this partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified INITRANS, MAXTRANS, STORAGE, PCTFREE, PCTUSED, and\/or [NO]LOGGING option to a Hash partition via ALTER TABLE ADD\/MOVE PARTITION command which is illegal. Only TABLESPACE may be specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove invalid option(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14261: partition bound may not be specified when adding this Hash partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified VALUES LESS THAN clause when adding a partition (via ALTER TABLE ADD PARTITION) to a Hash partitioned table which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove VALUES LESS THAN clause from the description of partition being added<\/span><\/span><\/p>\n

\n
<\/a> ORA-14262: new subpartition name must differ from the old subpartition name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User entered ALTER TABLE\/INDEX RENAME SUBPARTITION specifying\u00a0new-subpartition-name<\/i>\u00a0which is identical to the name of the subpartition being renamed<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the new subpartition name is different from the name of any (including the one being renamed) existing subpartition of a given table or index<\/span><\/span><\/p>\n

\n
<\/a> ORA-14263: New subpartition name must differ from that of any other partition or subpartition of the object.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE RENAME SUBPARTITION or ALTER INDEX RENAME SUBPARTITION specifying\u00a0new-subpartition-name<\/i>\u00a0which is identical to the name of an existing partition or subpartition of the object was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the new subpartition name is different from the name of any (including the one being renamed) existing partition or subpartition of a given table or index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14265: data type or length of a table subpartitioning 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 subpartition 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 subpartitioning column(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14266: data type or length of an index subpartitioning 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 subpartition 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 subpartitioning column(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-14267: cannot specify PARALLEL clause when adding a (composite) partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ALTER TABLE ADD PARTITION statement with PARALLEL clause for a partition or composite partition method other than HASH was issued.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the PARALLEL clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14268: subpartition ‘string<\/i>‘ of the partition resides in offlined tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted an operation requiring that we access data in a subpartition which resides in a tablespace which was taken offline. Such operations include trying to drop a tablespace of a table which has indices defined on it or is referenced by a constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Bring tablespace online before attempting the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14269: cannot exchange partition other than a Range,List,System, or Hash partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempt to exchange a partition with a non-partitioned table but the specified partition is not a Range,List,System, or Hash partition which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify EXCHANGE PARTITION for a Range,List,System, or Hash partition only<\/span><\/span><\/p>\n

\n
<\/a> ORA-14270: table is not partitioned by Range, System, Hash or List method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table in ALTER TABLE MODIFY PARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Range,List,System, or Hash method which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the table is partitioned by Range,List,System, or Hash method 14271, 00000, “free error number”<\/span><\/span><\/p>\n

\n
<\/a> ORA-14272: only a partition with higher bound can be reused<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempt to reuse a lower-bound partition in ALTER TABLE MERGE PARTITIONS statement as the resulting partition which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the higher-bound partition to be the resulting partition or specify a new partition name<\/span><\/span><\/p>\n

\n
<\/a> ORA-14273: lower-bound partition must be specified first<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified higher-bound partition before lower-bound partition in ALTER TABLE MERGE PARTITIONS statement which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify lower-bound partition then higher-bound partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14274: partitions being merged are not adjacent<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempt to merge two partitions that are not adjacent to each other which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify two partitions that are adjacent<\/span><\/span><\/p>\n

\n
<\/a> ORA-14275: cannot reuse lower-bound partition as resulting partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempt to reuse lower-bound partition of the partitions being merged which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify new resulting partition name or reuse the higher-bound partition only<\/span><\/span><\/p>\n

\n
<\/a> ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table in the ALTER TABLE EXCHANGE SUBPARTITION operation is either clustered or partitioned<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the table with which the subpartition is being exchanged for is not partitioned or clustered.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have different number of columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the two tables have the same number of columns with the same type and size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION are of different type or size<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the two tables have the same number of columns with the same type and size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have indexes which are not equivalent<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14280: all rows in table do not qualify for specified subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is at least one row in the non partitioned table which does not qualify for the subpartition specified in the ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all the rows in the segment qualify for the subpartition. Perform the alter table operation with the NO CHECKING option. Run ANALYZE table VALIDATE on that subpartition to find out the invalid rows and delete them.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION statement have CHECK constraint defined on them.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the two tables do not have CHECK constraint defined on any column<\/span><\/span><\/p>\n

\n
<\/a> ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION statement have different FOREIGN KEY constraints.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the two tables do not have FOREIGN KEY constraints defined on any column or disable all FOREIGN KEY constraints on both tables. Then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the tables named in the ALTER TABLE EXCHANGE SUBPARTITION command has a UNIQUE constraint for which no matching (vis-a-vis key columns) constraint is defined on the other table or a matching constraint is defined on the other table, but it differs from that defined on the first table vis-a-vis being enabled and\/or validated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that for every UNIQUE constraint defined on one of the tables named in the ALTER TABLE EXCHANGE SUBPARTITION statement there is a matching (vis-a-vis key columns and being enabled and\/or validated) UNIQUE constraint defined on the other table. If UNIQUE constrains are enabled, UNIQUE constraints on the partitioned table should be enforced using local indexes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14284: one or more of table’s subpartitions 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 subpartitions 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 subpartitions of which reside in read-only tablespaces<\/span><\/span><\/p>\n

\n
<\/a> ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that there is at least one partition. Drop the table or index to remove all partitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14286: cannot COALESCE the only subpartition of this table partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A COALESCE SUBPARTITION command was issued when there is only one subpartition in the partition which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that there is at least one subpartition. Drop partition to remove all subpartitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14287: cannot REBUILD a partition of a composite partitioned index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to rebuild a partition of a composite partitioned index which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0REBUILD the index partition one subpartition at a time.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14288: index is not partitioned by composite partition method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The index in a partition or subpartition maintenance operation (ALTER INDEX MODIFY [SUBPARTITION|DEFAULT ATTRIBUTES FOR PARTITION] or ALTER INDEX REBUILD SUBPARTITION command was not partitioned by the composite partition method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0REBUILD the index partition one at a time.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14289: cannot make local index partition of composite partitioned table unusable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to rebuild a partition of a composite partitioned index which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0REBUILD the index partition one subpartition at a time.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE [SUB]PARTITION statement have different PRIMARY KEY constraints.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the two tables do not have PRIMARY KEY constraints defined on any column or disable all PRIMARY KEY constraints on both tables. Then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A composite partition can only be exchanged with a partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the table being exchanged is partitioned or that that the partition being exchanged is non-composite.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14292: Partitioning type of table must match subpartitioning type of composite partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When exchanging a partitioned table with a composite partition the partitioning type of the table must match the subpartitioning type of the composite partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14293: Number of partitioning columns does not match number of subpartitioning columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When exchanging a partitioned table with a composite partition the number of partitioning columns of the table must match the number of subpartitioning columns of the composite partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of partitioning columns in the partitioned table is the same as the number of subpartitioning columns in the the composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14294: Number of partitions does not match number of subpartitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When exchanging a partitioned table with a composite partition the number of partitions of the table must match the number of subpartitions of the composite partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of partitions in the partitioned table is the same as the number of subpartitions in the the composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14295: column type or size mismatch between partitioning columns and subpartitioning columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When exchanging a partitioned table with a composite partition the type and size of the partitioning columns of the table must match the type and size of the subpartitioning columns of the composite partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the type and size of the partitioning columns of the partitioned is the same as the type and size of the subpartitioning columns of the composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The block sizes of the two tables specified in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different. For index organized tables, either the block sizes of the index or the overflow (or both) do not match.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the block sizes of the tables involved in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same. For index organized tables, ensure that the block sizes of both the index and the overflow of the two tables match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The block sizes of a pair of indexes being exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the block sizes of the corresponding pairs of indexes that need to be exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The block sizes of a pair of corresponding LOB columns of the two tables specified in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the block sizes of corresponding pairs of LOB columns of the tables involved in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14299: total number of partitions\/subpartitions exceeds the maximum limit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The total number of combined fragments specified in partitions \/subpartitions exceeds 1048575.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the statement with fewer number of fragments<\/span><\/span><\/p>\n

\n
<\/a> ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The row inserted had a partitioning key that maps to a partition number greater than 1048575<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the partitioning key falls within 1048575 partitions or subpartitions.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14070 to ORA-14300 ORA-14170: cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX Cause:\u00a0A request was made to generate default partition description(s) (possibly via PARTITIONS\u00a0number-of-partitions) while at the same time specified <(sub)partition-description> clause which is illegal. Action:\u00a0Remove one of offending clauses. ORA-14171: cannot specify\u00a0subpartition-description\u00a0clause in…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_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-2230","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-zY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2230","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=2230"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2230\/revisions"}],"predecessor-version":[{"id":2231,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2230\/revisions\/2231"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2230"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}