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

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

\n
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions<\/i><\/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
<\/a> ORA-14301: table-level attributes must be specified before partition-level attributes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0While processing an ALTER TABLE ADD COLUMN statement, table-level attributes of LOB columns were encountered after processing partition-level attributes of LOB columns or while processing CREATE TABLE statement, table-level attributes of LOB columns were encountered after processing partition descriptions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the SQL statement to specify table-level attributes prior to partition-level attributes or partition descriptions; then retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0While parsing an ALTER TABLE ADD COLUMN statement, one list of added-LOB-storage-clauses was parsed when another list of added-LOB-storage-clauses was encountered. There cannot be more than one list of added-LOB-storage-clauses in a statement; all added-LOB-storage-clauses must be combined into one list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Combine all of the lists of added-LOB-storage-clauses into one list and retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14303: partitions or subpartitions are not in the right order<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to rebuild a partition of a Composite Range partitioned index which is illegal<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-order the partitions or subpartitions in the added LOB storage clause by partition or subpartition DDL order, and retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-14304: List partitioning method expects a single partitioning column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0number of columns in a partitioning column list exceeded the legal limit of 1 for List partitioned objects<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14305: List value ‘string<\/i>‘ specified twice in partition ‘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>
\n<\/p>\n

\n
<\/a> ORA-14306: List value ‘string<\/i>‘ specified twice in partitions ‘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-14307: partition contains too many list values<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partition list contains more than 524288 list values<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the number of values to not exceed 524288 values<\/span><\/span><\/p>\n

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

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

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

\n
<\/a> ORA-14309: Total count of list values exceeds maximum allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partitioned object contains more than 524288 list values<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce number of values to less than 524288.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0VALUES LESS THAN or AT clause can be used only with Range partitioned tables<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14311: Expecting VALUES LESS THAN or AT clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0VALUES (value list<\/i>) clause can be used only with List partitioned tables<\/span><\/span><\/p>\n

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

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

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

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

\n
<\/a> ORA-14313: Value\u00a0string<\/i>\u00a0does not exist in partition\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 partition<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-14314: resulting List partition(s) must contain atleast 1 value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

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

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

Action:<\/b>\u00a0Re-submit operation with 2 distinct partition names<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0ALTER TABLE ADD|DROP VALUES can only be performed on List partitioned objects<\/span><\/span><\/p>\n

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

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

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

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

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

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

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

\n
<\/a> ORA-14319: DEFAULT cannot be specified with other values<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0DEFAULT keyword has been specified along with other values when specifying the values for a list partition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that if DEFAULT is specified, it is the only value specified<\/span><\/span><\/p>\n

\n
<\/a> ORA-14320: DEFAULT cannot be specified for ADD\/DROP VALUES or SPLIT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0DEFAULT keyword has been specified when doing a ADD VALUES or DROP VALUES or SPLIT partition or subpartition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that DEFAULT is not specified for ADD\/DROP VALUES or SPLIT partition\/subpartition operation.<\/span><\/span><\/p>\n

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

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

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

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

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

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

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

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

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

\n
<\/a> ORA-14324: values being added already exist in DEFAULT partition<\/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 partition<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT partition and then MERGE the split partition into the partition to which values need to be added<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14300 to ORA-14324 ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions Cause:\u00a0The row inserted had a partitioning key that maps to a partition number greater than 1048575 Action:\u00a0Ensure that the partitioning key falls within 1048575 partitions or subpartitions. ORA-14301: table-level attributes…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2232","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-A0","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2232","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=2232"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2232\/revisions"}],"predecessor-version":[{"id":2234,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2232\/revisions\/2234"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2232"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}