{"id":2238,"date":"2016-09-17T21:03:19","date_gmt":"2016-09-17T18:03:19","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2238"},"modified":"2017-02-15T21:05:04","modified_gmt":"2017-02-15T18:05:04","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14600-to-ora-14800","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-14600-to-ora-14800\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14600 to ORA-14800"},"content":{"rendered":"

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

\n
ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cannot specify these clauses while specifying a template<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the subpartition template clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SUBPARTITION TEMPLATE can be specified only for composite partitioned tables<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use SUBPARTITION TEMPLATE on non-partitioned or non-composite partitioned tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This syntax is valid only if subpartitioning dimension is hash<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Once a subpartition template has been specified during a CREATE TABLE it is illegal to specify SUBPARTITIONS or STORE IN anywhere else<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove either the SUBPARTITIONS | STORE IN or remove the SUBPARTITION TEMPLATE clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-14605: Name missing for subpartition \/ lob segment in template<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition \/ lob segment was not specified a name in the template descriptions<\/span><\/span><\/p>\n

Action:<\/b>\u00a0All subpartitions \/ lob segments must have names specified in the template<\/span><\/span><\/p>\n

<\/p>\n

\n
<\/a> ORA-14607: Tablespace was not specified for previous subpartitions in template but is specified for\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Tablespaces may either be specified for all subpartitions or must not be specified for any subpartitions<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify tablespaces for all or for none of the subpartitions<\/span><\/span><\/p>\n

\n
<\/a> ORA-14610: Lob attributes not specified for lob column\u00a0string<\/i>\u00a0for subpartition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Lob attributes of a column must be specified for all subpartitions or must not be specified at all<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure lob attributes of a column are specified for all subpartitions or not specified at all<\/span><\/span><\/p>\n

\n
<\/a> ORA-14611: Duplicate subpartition name\u00a0string<\/i>\u00a0in template<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition name cannot be duplicated within the template<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename one of the subpartitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14612: Duplicate lob segment name\u00a0string<\/i>\u00a0for lob column\u00a0string<\/i>\u00a0in template<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Two lob segments of the same column were given the same name in the template<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename one of the lob segments<\/span><\/span><\/p>\n

\n
<\/a> ORA-14613: Attempt to generate name from parent name\u00a0string<\/i>\u00a0and template name\u00a0string<\/i>\u00a0failed as the combine named would have been longer than allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Any name generated from a partition name and template name must be less than the maximum permissible name for an identifier<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shorten either partition or template name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14614: List value ‘string<\/i>‘ specified twice in subpartition ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/p>\n

\n
<\/a> ORA-14615: List value ‘string<\/i>‘ specified twice in subpartitions ‘string<\/i>‘, ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/p>\n

\n
<\/a> ORA-14616: table is not subpartitioned by List method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition maintenance operation, such as ALTER TABLE MODIFY SUBPARTITION ADD|DROP VALUES, was performed on a non-List subpartitioned object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the command against a List subpartitioned object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14617: cannot add\/drop values to DEFAULT subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A ADD\/DROP VALUES operation is being done on the default subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that ADD\/DROP VALUES is not done on the DEFAULT subpartition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14618: cannot drop the last value of subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE DROP VALUES tried to drop the last value of the subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Cannot execute the command, unless two or more values exist for subpartition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14619: resulting List subpartition(s) must contain at least 1 value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0After a SPLIT\/DROP VALUE of a list subpartition, each resulting subpartition(as applicable) must contain at least 1 value<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each of the resulting subpartitions contains atleast 1 value<\/span><\/span><\/p>\n

\n
<\/a> ORA-14620: DEFAULT subpartition already exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition already exists with DEFAULT value<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the DEFAULT value from the list specified<\/span><\/span><\/p>\n

\n
<\/a> ORA-14621: cannot add subpartition when DEFAULT subpartition exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ADD SUBPARTITION operation cannot be executed when a subpartition with DEFAULT values exists<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT subpartition instead<\/span><\/span><\/p>\n

\n
<\/a> ORA-14622: Value\u00a0string<\/i>\u00a0already exists in subpartition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the list values in the ADD SUBPARTITION or ADD VALUES statement already exists in another subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate value from the statement and try again<\/span><\/span><\/p>\n

\n
<\/a> ORA-14623: Value\u00a0string<\/i>\u00a0does not exist in subpartition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the list values in the SPLIT PARTITION or DROP VALUES statement does not exist in the subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the value from the statement and try again<\/span><\/span><\/p>\n

\n
<\/a> ORA-14624: DEFAULT subpartition must be last subpartition specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A subpartition description follows the one describing the default subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the DEFAULT subpartition is the last subpartition description<\/span><\/span><\/p>\n

\n
<\/a> ORA-14625: subpartition contains rows corresponding to values being dropped<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0table subpartition contains rows for the values being dropped.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0DELETE all rows for the values being dropped and reissue statement<\/span><\/span><\/p>\n

\n
<\/a> ORA-14626: values being added already exist in DEFAULT subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT subpartition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT subpartition and then MERGE the split subpartition into the subpartition to which values need to be added<\/span><\/span><\/p>\n

\n
<\/a> ORA-14627: Invalid operation was specified on a GLOBAL partitioned index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid operation such as ALTER INDEX DROP|SPLIT SUBPARTITION was specified on the global index<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that subpartition level operations are not specified on a GLOBAL index, since these are only RANGE partitioned<\/span><\/span><\/p>\n

\n
<\/a> ORA-14628: specification of bounds is inconsistent with LIST method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An operation such as ALTER TABLE SPLIT|ADD SUBPARTITION specified bounds that were inconsistent with List subpartitioning method<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify VALUES\/subpartition descriptions correctly for SPLIT\/ADD of List subpartitions<\/span><\/span><\/p>\n

\n
<\/a> ORA-14629: cannot drop the only subpartition of a partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A drop subpartition command is being executed when there is only one subpartition in the partition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-14630: subpartition 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-14631: the partition bounds do not match the subpartition bounds of the partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-14632: cannot specify PARALLEL clause when adding a List subpartition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User issued ALTER TABLE ADD SUBPARTITION statement with PARALLEL clause for a List subpartition of a Range\/List partitioned object which is illegal<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14633: Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The clause INVALIDATE or UPDATE GLOBAL INDEXES is allowed only for ADD hash subpartition to a composite partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove clause and reissue operation<\/span><\/span><\/p>\n

\n
<\/a> ORA-14634: Subpartition descriptions cannot be specified during the SPLIT\/MERGE of a partition of a Range-List partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0During a split or a merge of a partition of a range list partitioned table you cannot specify any subpartitioning information for the resulting partition (s)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all subpartitioning information from the DDL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE MERGE SUBPARTITIONS contained more than one resulting subpartition for the MERGE<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement describes exactly one subpartition as the target that need to be MERGEd<\/span><\/span><\/p>\n

\n
<\/a> ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE SPLIT SUBPARTITION contained more than 2 resulting subpartition for the SPLIT<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the statement describes exactly 2 subpartitions as the target of the SPLIT operation<\/span><\/span><\/p>\n

\n
<\/a> ORA-14637: cannot merge a subpartition with itself<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The same subpartition name was specified twice for the merge operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-submit operation with 2 distinct subpartition names within the same composite partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14638: cannot MERGE subpartitions in different Range Composite partitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to MERGE subpartitions in different Range Composite partitions<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the command after ensuring that the 2 subpartitions being merged lie in the same composite partition<\/span><\/span><\/p>\n

\n
<\/a> ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table\/partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to specify SUBPARTITIONS clause on table that is not partitioned by the Composite Range-Hash method<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the command after ensuring that the SUBPARTITIONS clause is not specified, to specify a template for a Composite Range List object use the SUBPARTITION TEMPLATE clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-14640: add\/coalesce index partition operation is valid only for hash partitioned global indexes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to add or coalesce an index partition of a global index not partitioned by hash method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue the statement on a global index partitioned by hash method. or if the index is partitioned by range method consider using split\/drop instead of add\/coalesce.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14641: STORE-IN clause can be specified only for a Hash, Interval, Autolist, Composite Range Hash, Composite Interval, Composite Autolist table or partition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Specifying a STORE-IN clause during creation or altering of a Range, Composite Range List partitioned table was not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-issue the statement after removing the STORE-IN clause.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The two tables in the EXCHANGE have usable bitmap indexes, and the INCLUDING INDEXES option has been specified and the tables have different hakan factors.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform the exchange with the EXCLUDING INDEXES option or alter the bitmap indexes to be unusable.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either records_per_block has been minimized for one of the tables to be exchanged, but not the other, or the hakan factors for the tables to be exchanged are not equal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If records_per_block has been minimized for one of the tables, but not the other, either perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables, or perform alter table with the MINIMIZE RECORDS_PER_BLOCK for both tables. If the hakan factors do not match perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0A subpartition maintenance operation such as ALTER TABLE MODIFY PARTITION COALESCE SUBPARTITION can only be performed on Hash subpartitioned objects<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-issue the command against a Hash subpartitioned object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14645: STORE IN clause cannot be specified for Range List objects<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A STORE IN clause was specified for Range List partitioned object<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-issue the command after removng the STORE IN clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The first time a table is altered to include compression, it cannot have a usable bitmap index (partition). Subsequent alter table statements involving compression do not have this same restriction.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0A) Drop any bitmap indexes defined on the table, and re-create them once the operation is complete or, B) Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14647: cannot MERGE subpartitions in different list composite partitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to MERGE subpartitions in different list composite partitions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the command after ensuring that the two subpartitions being merged lie in the same composite partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14650: operation not supported for reference-partitioned tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to perform an operation on a reference-partitioned table that was not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform the unsupported operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14651: reference partitioning constraint is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified partitioning constraint was not supported for reference-partitioned tables. The partitioning constraint must be enabled, validated, and not deferrable. The partitioning constraint must not have ON DELETE SET NULL semantics.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a supported partitioning constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14652: reference partitioning foreign key is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified partitioning foreign key was not supported for reference-partitioned tables. All columns of the partitioning foreign key must be constrained NOT NULL with enabled, validated, and not deferrable constraints. Furthermore, a virtual column cannot be part of the partitioning foreign key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a supported partitioning foreign key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14653: parent table of a reference-partitioned table must be partitioned<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a non-partitioned parent table.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14654: number of partitions of reference-partitioned table must equal that of the parent table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a number of partitions which was different from that of the parent table.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14655: reference partitioning constraint not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partitioning constraint specified in CREATE TABLE … PARTITION BY REFERENCE was not one of the referential constraints on the table being created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the specified partitioning constraint is one of the referential constraints on the table being created.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14656: cannot drop the parent of a reference-partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to drop the parent of a reference-partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop all reference-partitioned child tables before dropping the parent table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14657: cannot cascade row migration to reference-partitioned child table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Update of a parent key may require migration of rows in reference-partitioned child tables, however this is not supported because the parent key was not suitably indexed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Replace the existing index on the parent key with a unique index that does not contain any columns in addition to the parent key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14658: specified dependent table is not affected by this operation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A table has been specified in the DEPENDENT TABLES clause that is not a reference-partitioned table affected by the operation.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14659: Partitioning method of the parent table is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a reference-partitioned table with an interval partitioned parent table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not create a reference-partitioned table with an interval partitioned parent table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14660: parent table of a reference-partitioned table cannot be index-organized<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a index-organized parent table.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14661: row movement must be enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to disable row movement for a reference-partitioned table, although row movement was enabled for its parent table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Disable row movement for parent table before disabling row movement for the reference-partitioned table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14662: row movement cannot be enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to enable row movement for a partitioned table, although row movement was disabled for a reference-partitioned child table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable row movement for reference-partitioned child tables before enabling row movement for the parent table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14663: reference partitioning parent key is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parent key of the reference-partitioned table’s partitioning constraint contained virtual columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14664: Cannot use PL\/SQL expressions in reference partitioning parent key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that referenced a PL\/SQL expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14665: Cannot use expressions involving ROWID data type in reference partitioning parent key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved the ROWID data type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14666: Cannot use expressions involving BLOB or CLOB data types in reference partitioning parent key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved a BLOB or CLOB data type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14667: Cannot use expressions involving object data types in reference partitioning parent key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved an object data type (object, REF, nested table, array).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14668: Cannot drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop all reference-partitioned child tables before dropping the unique or primary key of the parent table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14669: interval partition of reference-partitioned table must correspond to interval partition of the parent table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a reference-partitioned table with an interval partiton that does not pair with an interval partition in the parent table.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14670: there is no usable index on the reference partitioning parent key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to run an operation on a reference partitioned table that requires a usable index on the reference partitioning parent key, but no such index exists.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a usable index on the reference partitioning parent key, or rebuild the existing unusable index on the reference partitioning parent key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14690: value too long for MIN or MAX aggregate<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a MIN or MAX aggregate with a value that was too long.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Limit the size of MIN and MAX aggregate inputs to 32763 bytes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14691: Extended character types are not allowed in this table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create VARCHAR2 or NVARCHAR2 columns larger than 4000 bytes, or a RAW column larger than 2000 bytes, in a cluster, clustered table or index-organized table.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14692: STORE AS clause is not allowed for extended character type column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use the STORE AS clause to specify storage attributes for an extended character type column.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to set the MAX_STRING_SIZE parameter to STANDARD in a database that has been created with, or migrated to, the EXTENDED setting.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set MAX_STRING_SIZE to EXTENDED and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to update the MAX_STRING_SIZE parameter to EXTENDED when the database was not in UPGRADE mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the database in UPGRADE mode, modify the parameter, run the utl32k.sql script in $ORACLE_HOME\/rdbms\/admin, and restart the database in normal mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14695: MAX_STRING_SIZE migration is incomplete<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to open the database in normal mode before the MAX_STRING_SIZE migration process completed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the database in UPGRADE mode, run the utl32k.sql script in $ORACLE_HOME\/rdbms\/admin, and restart the database in normal mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14696: MAX_STRING_SIZE migration is incomplete for pluggable database\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to open the database in normal mode before the MAX_STRING_SIZE migration process completed for the specified pluggable database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the database in UPGRADE mode, run the utl32k.sql script in $ORACLE_HOME\/rdbms\/admin in the specified pluggable database, and restart the database in normal mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14697: This connection does not support bind variables larger than 4000 bytes for SQL statements.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a bind variable larger than 4000 bytes for a SQL statement when the client initially connected to a container with STANDARD MAX_STRING_SIZE, and then within the same session switched to a container with EXTENDED MAX_STRING_SIZE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Initialize a new connection for the container with EXTENDED MAX_STRING_SIZE and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14698: MAX_STRING_SIZE migration to STANDARD is not allowed due to column\u00a0string<\/i>\u00a0in object\u00a0string<\/i>.string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a bind variable larger than 4000 bytes for a SQL statement when the client initially connected to a container with STANDARD MAX_STRING_SIZE, and then within the same session switched to a container with EXTENDED MAX_STRING_SIZE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Initialize a new connection for the container with EXTENDED MAX_STRING_SIZE and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14699: long bind value is too large for column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to bind a value larger than 4000 bytes for insert or update of a VARCHAR2, NVARCHAR2, or RAW column, and the value was too large for the destination column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either make the destination column larger, or reduce the size of the bind value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on object, or non-SYS user should connect as SYS<\/span><\/span><\/p>\n

\n
<\/a> ORA-14701: partition-extended name or bind variable must be used for DMLs on tables partitioned by the System method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted not to use partition-extended syntax for a table partitioned by the System method<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Must use of partition-extended syntax in contexts mentioned above.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14702: The partition number is invalid or out-of-range<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to use nonnumerical value or the number was out of range of the partitions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a valid partition number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14703: The AFTER clause can be used to ADD PARTITION only to a System Partitioned table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table is not partitioned by the System method<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Skip the AFTER clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14704: Create table as select disallowed for SYSTEM patitioned tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to create a SYSTEM partitioned table by doing a create table as select.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do a create table followed by an insert as select into each partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14705: unique or primary keys referenced by enabled foreign keys in table “string<\/i>“.”string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to truncate a table with unique or primary keys referenced by enabled foreign keys in another table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Before performing the TRUNCATE operation on the table, disable the foreign key constraints in other tables. You can see what constraints exist in a table by issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = :1;<\/span><\/span><\/p>\n

\n
<\/a> ORA-14706: multiple child tables reference constraint “string<\/i>” in table “string<\/i>“.”\u00a0string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command found that the specified parent key in the specified table was referenced by partitioning constraints in multiple reference partitioned child tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform EXCHANGE [SUB]PARTITION without the CASCADE option. The CASCADE option is not supported if a parent key in the reference partitioned table hierarchy is referened by multiple partitioning constraints.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14707: no match found for table “string<\/i>“.”\u00a0string<\/i>” for EXCHANGE CASCADE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was no table matching the specified table in the ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform EXCHANGE [SUB]PARTITION without the CASCADE option or ensure that exactly one table matches the specified table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14708: multiple matches found for table “string<\/i>“.”\u00a0string<\/i>” for EXCHANGE CASCADE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There were multiple tables matching the specified table in the ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform EXCHANGE [SUB]PARTITION without the CASCADE option or ensure that exactly one table matches the specified table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14709: index mismatch for table “string<\/i>“.”string<\/i>” in ALTER TABLE EXCHANGE [SUB]PARTITION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ALTER TABLE EXCHANGE [SUB]PARTITION command was attempted for the specified table, however, the exchange table did not have equivalent indexes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the indexes for the two tables have indexes which follow this rule: For every nonpartitioned index for the nonpartitioned table, there has to be an identical LOCAL index on the partitioned table and vice versa. To be identical, the column position type and size have to be the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14710: domain index “string<\/i>” found for table “string<\/i>“.”string<\/i>” for EXCHANGE CASCADE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command was attempted for the specified table. However, there was a domain index on the specified table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform EXCHANGE [SUB]PARTITION without the CASCADE option or ensure that there is no domain index on the specified table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14750: Range partitioned table with INTERVAL clause has more than one column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You attempted to create an interval partitioned table with more than one partitioning column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a single partitioning column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14751: Invalid data type for partitioning column of an interval partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You attempted to use interval partitioning on a table partitioned on a column of data type other than number or date\/time.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only number or date\/time columns as partitioning columns for interval partitioned tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14752: Interval expression is not a constant of the correct type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only constant expressions for the interval. If the data type of partitioning column is numeric, the interval must be a numeric constant. If the data type is of type date\/time, the interval must be a constant of interval type<\/span><\/span><\/p>\n

\n
<\/a> ORA-14753: Interval cannot be zero<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The interval mapped to zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You must use a nonzero interval.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14754: Interval string is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The interval string was too long<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify interval using a shorter string<\/span><\/span><\/p>\n

\n
<\/a> ORA-14755: Invalid partition specification for FOR VALUES clause.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The [SUB]PARTITION FOR VALUES (…) clause can only take constants. In addition it takes as many arguments as there are partitioning columns and the values must be coercible to the partitioning columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid FOR VALUES clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14756: Table is not partitioned by the interval or by the autolist method.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table was not partitioned by the interval or by the autolist method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0ALTER TABLE SET STORE IN is only valid for interval or autolist partitioned tables. Ensure that the table is partitioned by an interval or by an autolist method.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14757: Table is already a range partitioned table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SET INTERVAL () is used to convert an interval partitioned table to a range partitioned table. It is not legal on a range partitioned table<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use SET INTERVAL () only on an interval partitioned table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14758: Last partition in the range section cannot be dropped<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop the last range partition of an interval partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to drop this partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14759: SET INTERVAL is not legal on this table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SET INTERVAL clause was specified. ALTER TABLE SET INTERVAL is only legal on a range partitioned table with a single partitioning column. Additionally, this table cannot have a MAXVALUE partition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use SET INTERVAL only on a valid table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER TABLE ADD PARTITION was attempted on an Interval partitioned object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform the operation on an Interval partitioned object. Insert a row to create the new partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14761: MAXVALUE [sub]partition cannot be specified for INTERVAL [sub]partitioned objects.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a [sub]partition with a MAXVALUE highbound on an INTERVAL [sub]partitioned object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not create a [sub]partition with a MAXVALUE highbound.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14762: Domain index creation on interval partitioned tables is not permitted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a domain index on an interval partitioned table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not create a domain index on an interval partitioned table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14763: Unable to resolve FOR VALUES clause to a partition number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Could not determine the partition corresponding to the FOR VALUES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove bind variables and dependencies on session parameters from the values specified in the FOR VALUES clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14764: Partitions cannot be truncated, dropped or merged with mixed syntax.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to truncate, drop or merge partitions with mixed syntax.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use mixed syntax to truncate, drop or merge partitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14765: Cannot create a partition while doing a create index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a partition concurrently with index creation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry the statement after the index build is finished.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14766: Unable to obtain a stable metadata snapshot<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This operation was not able to obtain a stable snapshot of the interval partitioning metadata.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14767: Cannot specify this interval with existing high bounds<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The interval specified conflicts with the existing high bound for the last partition. The combination might lead to invalid dates for high bounds in the future.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If this is a CREATE TABLE, try specifying a different high bound value for the last partition, or a different interval. If this is an ALTER TABLE SET INTERVAL, please choose either a different interval, or, modify the table to change the high bound for the last partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14769: cannot interval [sub]partition or autolist [sub]partition nested table or XMLType with object-relational storage<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Interval [sub] partition or autolist [sub]partition was not supported for nested table and XMLType with object-relational storage.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a list or range partition instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14770: Cannot use an XML virtual column whose expression uses EXTRACTVALUE operator to interval [sub]partition a table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Interval [sub]partition is not supported with an XML virtual column whose expression include the EXTRACTVALUE operator<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use XMLCAST and XMLQUERY operators to define the virtual column expression for the partitioning key during interval [sub]partition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14801: Hash composite partitioning is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to partition a table using a Hash composite method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not partition the table by a Hash composite method.<\/span><\/span><\/p>\n

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14600 to ORA-14800 ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template Cause:\u00a0Cannot specify these clauses while specifying a template Action:\u00a0Correct the subpartition template clause. ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table Cause:\u00a0SUBPARTITION TEMPLATE can be specified only for…<\/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":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2238","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-A6","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2238","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=2238"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2238\/revisions"}],"predecessor-version":[{"id":2239,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2238\/revisions\/2239"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2238"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}