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

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

\n
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
<\/a><\/a>ORA-14301: table-level attributes must be specified before partition-level attributes<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Combine all of the lists of added-LOB-storage-clauses into one list and retry the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14303: partitions or subpartitions are not in the right order<\/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>\u00a0Re-order the partitions or subpartitions in the added LOB storage clause by partition or subpartition DDL order, and retry the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14304: List partitioning method expects a single partitioning column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0number of columns in a partitioning column list exceeded the legal limit of 1 for List partitioned objects<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0modify partitioning column list so that it consists of at most 1 column<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14305: List value ‘string<\/i>‘ specified twice in partition ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14306: List value ‘string<\/i>‘ specified twice in partitions ‘string<\/i>‘, ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14307: partition contains too many list values<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Partition list contains more than 524288 list values<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reduce the number of values to not exceed 524288 values<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that all elements of partition bound list are of valid type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14309: Total count of list values exceeds maximum allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Partitioned object contains more than 524288 list values<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reduce number of values to less than 524288.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0VALUES LESS THAN or AT clause can be used only with Range partitioned tables<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use VALUES (<value list>) clause with List partitioned tables<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14311: Expecting VALUES LESS THAN or AT clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0VALUES (<value list>) clause can be used only with List partitioned tables<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use VALUES LESS THAN clause with Range partitioned tables<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-14312: Value\u00a0string<\/i>\u00a0already exists in partition\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the list values in the ADD PARTITION or ADD VALUES statement already exists in another partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate value from the statement and try again<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14313: Value\u00a0string<\/i>\u00a0does not exist in partition\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the list values in the SPLIT PARTITION or DROP VALUES statement does not exist in the partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the value from the statement and try again<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14314: resulting List partition(s) must contain atleast 1 value<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that each of the resulting partitions contains atleast 1 value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14315: cannot merge a partition with itself<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The same partition name was specified twice for the merge operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-submit operation with 2 distinct partition names<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14316: table is not partitioned by List method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE ADD|DROP VALUES can only be performed on List partitioned objects<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the command against a List partitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14317: cannot drop the last value of partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE DROP VALUES tried to drop the last value of the partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Cannot execute the command, unless two or more values exist for partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14318: DEFAULT partition must be last partition specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A partition description follows the one describing the default partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the DEFAULT partition is the last partition description<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14319: DEFAULT cannot be specified with other values<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DEFAULT keyword has been specified along with other values when specifying the values for a list partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that if DEFAULT is specified, it is the only value specified<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14320: DEFAULT cannot be specified for ADD\/DROP VALUES or SPLIT<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DEFAULT keyword has been specified when doing a ADD VALUES or DROP VALUES or SPLIT partition or subpartition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that DEFAULT is not specified for ADD\/DROP VALUES or SPLIT partition\/subpartition operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14321: cannot add\/drop values to DEFAULT partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A ADD\/DROP VALUES operation is being done on the default partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that ADD\/DROP VALUES is not done on the DEFAULT partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14322: DEFAULT partition already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A partition already exists with DEFAULT value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14323: cannot add partition when DEFAULT partition exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An ADD PARTITION operation cannot be executed when a partition with DEFAULT values exists<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT partition instead<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14324: values being added already exist in DEFAULT partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT partition<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-14325: only LOCAL indexes may be specified in this clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A global index has been specified in the UPDATE INDEXES (..) clause<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only specify local indexes when using this clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A Primary index on an IOT, DOMAIN or LOB index has been specified in the UPDATE INDEXES (..) clause<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify any of these indexes when using this clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14327: Some index [sub]partitions could not be rebuilt<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The first phase (partition DDL and index [sub]partition placement) completed successfully. During the second phase, some of the index [sub]partitions could not be rebuilt.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14329: domain index [sub]partitions cannot be renamed in this clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user tried to rename a domain index [sub]partition in the UPDATE INDEXES clause of a ALTER TABLE MOVE [SUB]PARTITION operation. This is not allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Leave the name blank or use the same name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14330: Cannot drop a partition of a global hash-partitioned index<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a partition of a hash-partitioned global index.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try COALESCE PARTITION instead.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14400: inserted partition key does not map to any partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to insert a record into, a Range or Composite Range object, with a concatenated partition key that is beyond the concatenated partition bound list of the last partition -OR- An attempt was made to insert a record into a List object with a partition key that did not match the literal values specified for any of the partitions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not insert the key. Or, add a partition capable of accepting the key, Or add values matching the key to a partition specification<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14401: inserted partition key is outside specified partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the concatenated partition key of an inserted record is outside the ranges of the two concatenated partition bound lists that delimit the partition named in the INSERT statement<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0do not insert the key or insert it in another partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14402: updating partition key column would cause a partition change<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An UPDATE statement attempted to change the value of a partition key column causing migration of the row to another partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to update a partition key column or make sure that the new partition key is within the range containing the old partition key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14403: cursor invalidation detected after getting DML partition lock<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0cursor invalidation was detected after acquiring a partition lock during an INSERT, UPDATE, DELETE statement. This error is never returned to user, because is caught in opiexe() and the DML statement is retried.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0nothing to be done, error should never be returned to user<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14404: partitioned table contains partitions in a different tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a tablespace which contains tables whose partitions are not completely contained in this tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0find tables with partitions which span the tablespace being dropped and some other tablespace(s). Drop these tables or move partitions to a different tablespace<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14405: partitioned index contains partitions in a different tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a tablespace which contains indexes whose partitions are not completely contained in this tablespace, and which are defined on the tables which are completely contained in this tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0find indexes with partitions which span the tablespace being dropped and some other tablespace(s). Drop these indexes, or move the index partitions to a different tablespace, or find the tables on which the indexes are defined, and drop (or move) them.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14406: updated partition key is beyond highest legal partition key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0At attempt was made to update a record with a concatenated partition key that is beyond the concatenated partition bound list of the last partition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not update the key. Or, add a partition capable of accepting the key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14407: partitioned table contains subpartitions in a different tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a tablespace which contains tables whose subpartitions are not completely contained in this tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0find tables with subpartitions which span the tablespace being dropped and some other tablespace(s). Drop these tables or move subpartitions to a different tablespace<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14408: partitioned index contains subpartitions in a different tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a tablespace which contains indexes whose subpartitions are not completely contained in this tablespace, and which are defined on the tables which are completely contained in this tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0find indexes with subpartitions which span the tablespace being dropped and some other tablespace(s). Drop these indexes, or move the index partitions to a different tablespace, or find the tables on which the indexes are defined, and drop (or move) them.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14409: inserted partition key is outside specified subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the concatenated partition key of an inserted record is outside the ranges of the two concatenated subpartition bound lists that delimit the subpartition named in the INSERT statement<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0do not insert the key or insert it in another subpartition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14411: The DDL cannot be run concurrently with other DDLs<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Another conflicting DDL was already running.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry after the conflicting DDL has finished.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14450: attempt to access a transactional temp table already in use<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access a transactional temporary table that has been already populated by a concurrent transaction of the same session.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0do not attempt to access the temporary table until the concurrent transaction has committed or aborted.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14451: unsupported feature with temporary table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create an IOT, specify physical attributes, specify partition or parallel clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0do not do that.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14452: attempt to create, alter or drop an index on temporary table already in use<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create, alter or drop an index on temporary table which is already in use.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0All the sessions using the session-specific temporary table have to truncate table and all the transactions using transaction specific temporary table have to end their transactions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use LOB from a temporary table whose data has been dropped either because table was transaction-specific and transaction has commited or aborted, table was truncated or session which created this LOB has ended.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This LOB locator is invalid and cannot be used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14454: attempt to reference temporary table in a referential integrity constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to reference temporary table in a referencial integrity constraint. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use triggers.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14455: attempt to create referential integrity constraint on temporary table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a referential integrity constraint on a temporary table. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use triggers.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14456: cannot rebuild index on a temporary table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to rebuild an index on a temp table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The index data is anyway lost at end of session\/transaction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14457: disallowed Nested Table column in a Temporary table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt made to create a Nested Table column in a temporary table. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify these datatypes for temporary tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14458: attempt was made to create a temporary table with INDEX organization<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create an Index Organized Temporary table. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the table with HEAP organization and the primary key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14459: missing GLOBAL keyword<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0keyword GLOBAL is missing while creating temporary table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0supply keyword.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0COMPRESS was specified more than once, NOCOMPRESS was specified more than once, or both COMPRESS and NOCOMPRESS were specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify each desired COMPRESS or NOCOMPRESS clause option only once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14461: cannot REUSE STORAGE on a temporary table TRUNCATE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0REUSE STORAGE was specified with TRUNCATE on a temporary table. This is unsupported as it is meaningless.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify DROP STORAGE instead (which is the default).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14462: cannot TRUNCATE temporary table in an autonomous transaction which is already in use by the parent transaction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to TRUNCATE a temporary table in an autonomous transaction which is already in use by the parent transaction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the temporary table is not being used by the parent transaction before trying to TRUNCATE in an autonomous transaction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14463: OPERATIONS keyword not specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0OPERATIONS keyword was not specified in the Compression Clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify OPERATIONS in the Compression Clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14464: Compression Type not specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Compression Type was not specified in the Compression Clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify Compression Type in the Compression Clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14465: Fast-Split is not possible on these partitions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast-Split event was forced in this session.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Disable the event that forces Fast-Split.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14500: LOCAL option not valid without partition name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14300 to ORA-14500 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 must…<\/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":[14,32,54],"class_list":["post-1917","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-uV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1917","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=1917"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1917\/revisions"}],"predecessor-version":[{"id":1918,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1917\/revisions\/1918"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1917"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}