{"id":1912,"date":"2016-04-21T10:05:04","date_gmt":"2016-04-21T07:05:04","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1912"},"modified":"2016-10-26T10:06:40","modified_gmt":"2016-10-26T07:06:40","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-14080-to-ora-14100","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-14080-to-ora-14100\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-14200 to ORA-14300"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14200 to ORA-14300<\/strong><\/p>\n

\n
ORA-14201: specified subpartition bound is too long<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14202: subpartition bound of subpartition “string<\/i>” is too high<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14203: subpartition bound of subpartition “string<\/i>” is too long<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14204: subpartition bound of subpartition number\u00a0string<\/i>\u00a0is too high<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14205: subpartition bound of subpartition number\u00a0string<\/i>\u00a0is too long<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Change the representation of a subpartition high bound to bring its length within legal limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14206: table is not subpartitioned by List or Range methods<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Issue the command only against a List or Range subpartitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14207: maximum number of subpartitioning columns is 16<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0number of columns in a subpartitioning column list exceeded the legal limit of 16<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0modify subpartitioning column list so that it consists of at most 16 columns<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14208: lower-bound subpartition must be specified first<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A higher-bound subpartition was specified before the lower-bound subpartition in ALTER TABLE MERGE SUBPARTITIONS statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify lower-bound subpartition first and then higher-bound subpartition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14209: subpartitions being merged are not adjacent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to merge two subpartitions that are not adjacent to each other.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify two subpartitions that are adjacent<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14210: cannot reuse lower-bound subpartition as resulting subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to reuse the lower-bound subpartition of the subpartitions being merged.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify new resulting subpartition name or reuse the higher-bound subpartition only<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-14211: subpartition bound must collate higher than that of the last subpartition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14212: subpartition cannot be split along the specified high bound<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14213: VALUES LESS THAN or AT clause cannot be used for List subpartitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0VALUES LESS THAN or AT clause was used for List subpartitioned tables<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use VALUES (<value list>) clause for List subpartitioned tables<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14214: VALUES (<value list>) cannot be used for Range subpartitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0VALUES (<value list>) clause was used for Range subpartitioned tables<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use VALUES LESS THAN or AT clause with Range subpartitioned tables<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14215: subpartition bound list contains too many elements<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Subpartition bound list contained more elements than there are subpartitioning columns<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14216: subpartition bound list contains too few elements<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Subpartition bound list contained fewer elements than there are subpartitioning columns<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14217: VALUES (<value list>) clause expected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0VALUES (<value list>) clause was not specified for the list subpartition being added<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a VALUES (<value list>) clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14218: Invalid operation for object without a segment<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object (table or index or lob) did not have a segment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create segments for the object with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14220: Invalid operation for object without a segment<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to modify storage or allocate an extent for an object (table or LOB or index) without a segment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create segments for the object with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14221: Dictionary managed tablespace cannot be used for this operation<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a locally managed tablespace OR create segments for the table with the ALTER TABLE ALLOCATE EXTENT command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14223: Deferred segment creation is not supported for this table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The SEGMENT CREATION DEFERRED clause was specified in the CREATE TABLE statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the SEGMENT CREATION DEFERRED clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14251: Specified subpartition does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Subpartition not found for the object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry with correct subpartition name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only ALLOCATE EXTENT and DEALLOCATE UNUSED may be specified in ALTER TABLE MODIFY PARTITION for a Hash partition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14253: table is not partitioned by Composite Range method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table in a subpartition maintenance operation (ALTER TABLE EXCHANGE\/MODIFY\/MOVE\/TRUNCATE SUBPARTITION, or ALTER TABLE MODIFY PARTITION ADD\/COALESCE SUBPARTITION command must be partitioned by Composite Range method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table is partitioned by Composite Range method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14255: table is not partitioned by Range, List, Composite Range or Composite List method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table was not partitioned by Range, List, Composite Range or Composite List method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0ALTER TABLE SPLIT\/DROP PARTITION or ALTER TABLE MERGE PARTITIONS command is only valid for table partitioned by Range, List, Composite Range or Composite List methods. Ensure that the table is partitioned appropriately.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14256: invalid resulting partition description(s)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User specified STORE-IN clause, SUBPARTITIONS clause, and\/or <subpartition-description> clause 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><\/span><\/dd>\n
Action:<\/b>\u00a0Remove invalid clause(s), or ensure that the table is partitioned by Composite Range method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14257: cannot move partition other than a Range, List, System, or Hash partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempt to move a partition that is not a Range,List,System, or Hash partition which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify MOVE PARTITION for a Range,List,System, or Hash partition only<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14258: invalid partition description<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User specified STORE-IN clause, SUBPARTITIONS clause, and\/or <subpartition-description> clause 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><\/span><\/dd>\n
Action:<\/b>\u00a0Remove invalid clause(s), or ensure that the table is partitioned by Composite Range\/Hash method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14259: table is not partitioned by Hash method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE COALESCE PARTITION is only valid for table partitioned by Hash method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify valid ALTER TABLE option for the table, or ensure that the table is partitioned by Hash method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14260: incorrect physical attribute specified for this partition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Remove invalid option(s)<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14261: partition bound may not be specified when adding this Hash partition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Remove VALUES LESS THAN clause from the description of partition being added<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14262: new subpartition name must differ from the old subpartition name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User entered ALTER TABLE\/INDEX RENAME SUBPARTITION specifying <new-subpartition-name> which is identical to the name of the subpartition being renamed<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14263: new subpartition name must differ from that of any other subpartition of the object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User entered ALTER TABLE\/INDEX RENAME SUBPARTITION specifying <new-subpartition-name> which is identical to the name of some existing subpartition of the object<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14264: table is not partitioned by Composite Range method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table in the MODIFY DEFAULT ATTRIBUTES FOR PARTITION operation is partitioned by method other than Composite method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table is partitioned by Composite method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14265: data type or length of a table subpartitioning column may not be changed<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid modifying data type and\/or length of table subpartitioning column(s)<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14266: data type or length of an index subpartitioning column may not be changed<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid modifying data type and\/or length of index subpartitioning column(s)<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User issued ALTER TABLE ADD PARTITION statement with PARALLEL clause for a Range or Composite Range partition which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14268: subpartition ‘string<\/i>‘ of the partition resides in offlined tablespace<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Bring tablespace online before attempting the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14269: cannot exchange partition other than a Range,List,System, or Hash partition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Specify EXCHANGE PARTITION for a Range,List,System, or Hash partition only<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14270: table is not partitioned by Range, System, Hash or List method<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table is partitioned by Range,List,System, or Hash method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14271: table is not partitioned by Composite Range method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table in ALTER TABLE MODIFY SUBPARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Composite Range method which is illegal.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table is partitioned by Composite Range method<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14272: only a partition with higher bound can be reused<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Use the higher-bound partition to be the resulting partition or specify a new partition name<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14273: lower-bound partition must be specified first<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User specified higher-bound partition before lower-bound partition in ALTER TABLE MERGE PARTITIONS statement which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify lower-bound partition then higher-bound partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14274: partitions being merged are not adjacent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempt to merge two partitions that are not adjacent to each other which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify two partitions that are adjacent<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14275: cannot reuse lower-bound partition as resulting partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempt to reuse lower-bound partition of the partitions being merged which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify new resulting partition name or reuse the higher-bound partition only<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table in the ALTER TABLE EXCHANGE SUBPARTITION operation is either clustered or partitioned<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table with which the subpartition is being exchanged for is not partitioned or clustered.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have different number of columns<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the two tables have the same number of columns with the same type and size.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION are of different type or size<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the two tables have the same number of columns with the same type and size.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have indexes which are not equivalent<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14280: all rows in table do not qualify for specified subpartition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the two tables do not have CHECK constraint defined on any column<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION statement have different FOREIGN KEY constraints.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14284: one or more of table’s subpartitions reside in a read-only tablespace<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid performing aformentioned operations on a partitioned table one or more subpartitions of which reside in read-only tablespaces<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that there is at least one partition. Drop the table or index to remove all partitions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14286: cannot COALESCE the only subpartition of this table partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A COALESCE SUBPARTITION command was issued when there is only one subpartition in the partition which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that there is at least one subpartition. Drop partition to remove all subpartitions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to rebuild a partition of a Composite Range partitioned index which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0REBUILD the index partition, a subpartition at a time<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14288: index is not partitioned by Composite Range method<\/span><\/b><\/span><\/span><\/dt>\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 must be partitioned by Composite Range method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14289: cannot make local index partition of Composite Range partitioned table unusable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to rebuild a partition of a Composite Range partitioned index which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A composite partition can only be exchanged with a partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the table being exchanged is partitioned or that that the partition being exchanged is non-composite.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14292: Partitioning type of table must match subpartitioning type of composite partition<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14293: Number of partitioning columns does not match number of subpartitioning columns<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14294: Number of partitions does not match number of subpartitions<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14295: column type or size mismatch between partitioning columns and subpartitioning columns<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14299: total number of partitions\/subpartitions exceeds the maximum limit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The total number of combined fragments specified in partitions \/subpartitions exceeds 1048575.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the statement with fewer number of fragments<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The row inserted had a partitioning key that maps to a partition number greater than 1048575<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the partitioning key falls within 1048575 partitions or subpartitions.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14200 to ORA-14300 ORA-14201: specified subpartition bound is too long Cause:\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). Action:\u00a0Change the representation of…<\/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":[14,32,54],"class_list":["post-1912","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-uQ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1912","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=1912"}],"version-history":[{"count":4,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1912\/revisions"}],"predecessor-version":[{"id":1916,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1912\/revisions\/1916"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1912"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}