ORA-10000 to ORA-19999

ORA-12401: invalid label string

• Error code in OceanBase Database: 5696

• SQLSTATE: HY000

• Cause: The strategy cannot convert the label string into a valid internal label.

• Solution: Correct the syntax of the label string.

ORA-12416: policy string not found

• Error code in OceanBase Database: 5695

• SQLSTATE: HY000

• Cause: The specified strategy does not exist in the database.

• Solution: Enter a correct strategy name or create a strategy.

ORA-12432: LBAC error: %s

• Error code in OceanBase Database: 5700

• SQLSTATE: HY000

• Cause: Label-based access control (LBAC) is performed.

• Solution: Correct the problem identified in the error message.

ORA-12444: policy already applied to table

• Error code in OceanBase Database: 5790

• SQLSTATE: HY000

• Cause: You are applying a strategy to a table that is already under strategy protection.

• Solution: If you need to modify the table options, predicate, or label function, you must first remove the strategy from the table and then reapply it.

ORA-12447: policy role already exists for policy string

• Error code in OceanBase Database: 5701

• SQLSTATE: HY000

• Cause: A strategy with the specified name already exists.

• Solution: Change the strategy name or delete the existing strategy.

ORA-12461: undefined level string for policy string

• Error code in OceanBase Database: 5698

• SQLSTATE: HY000

• Cause: The specified level is not defined for the strategy.

• Solution: Specify a level identifier value for the strategy.

ORA-12462: undefined compartment string for policy string

• Error code in OceanBase Database: 5697

• SQLSTATE: HY000

• Cause: The specified component is not defined for the strategy.

• Solution: Specify a component identifier value for the strategy.

ORA-12463: undefined group string for policy string

• Error code in OceanBase Database: 5699

• SQLSTATE: HY000

• Cause: The specified group is not defined for the strategy.

• Solution: Specify a group identifier value for the strategy.

ORA-12470: NULL or invalid user label: %s

• Error code in OceanBase Database: 5702

• SQLSTATE: HY000

• Cause: The entered user label is NULL or is beyond the authorization of the user.

• Solution: Enter an authorized label for the user.

ORA-12702: invalid NLS parameter string used in SQL function

• Error code in OceanBase Database: 5604

• SQLSTATE: HY000

• Cause: An unknown argument name or an invalid value is specified in the NLS argument string.

ORA-12704: COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'

• Error code in OceanBase Database: 5144

• SQLSTATE: 42000

• Cause:

  • Different character sets are used for the string operands (excluding nlsparams) of the operator or built-in function.

  • The nlsparams operand is not contained in the character set of the database.

  • A character set other than the character set of the database is used for the string data passed to the built-in function, but the built-in function does not support the character set in use.

  • The second argument of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.

  • The character set of the string expression in the VALUES clause of the INSERT statement or the SET clause of the UPDATE statement is different from the character set used by the column to be inserted.

  • In the table creation statement, the character set used for the values in the DEFAULT clause is different from the character set declared for the column.

  • An argument of the PL function does not meet the character set requirements of the argument.

ORA-12704: character set mismatch

• Error code in OceanBase Database: 5808

• SQLSTATE: HY000

• Cause:

  • Different character sets are used for the string operands (excluding nlsparams) of the operator or built-in function.

  • The nlsparams operand is not contained in the character set of the database.

  • A character set other than the character set of the database is used for the string data passed to the built-in function, but the built-in function does not support the character set in use.

  • The second argument of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.

  • The character set of the string expression in the VALUES clause of the INSERT statement or the SET clause of the UPDATE statement is different from the character set used by the column to be inserted.

  • In the table creation statement, the character set used for the values in the DEFAULT clause is different from the character set declared for the column.

  • An argument of the PL function does not meet the character set requirements of the argument.

ORA-12705: Cannot access NLS data files or invalid environment specified

• Error code in OceanBase Database: 5943

• SQLSTATE: HY000

• Cause:

  • An invalid NLS parameter or value is specified in the ALTER SESSION statement.

  • The name of environment variable NLS_LANG, ORA_NLSxx, or ORACLE_HOME is incorrectly spelled, and therefore the NLS data file cannot be found.

• Solution:

  • Check the syntax of the ALTER SESSION statement and the NLS parameter, correct the syntax errors, and try this statement again.

  • Ensure that the name of the environment variable is correctly spelled.

ORA-12725: unmatched parentheses in regular expression

• Error code in OceanBase Database: 5813

• SQLSTATE: HY000

• Cause: Parentheses (()) in the regular expression do not appear in pairs.

• Solution: Ensure that the parentheses are symmetric.

ORA-12726: unmatched bracket in regular expression

• Error code in OceanBase Database: 5812

• SQLSTATE: HY000

• Cause: Square brackets ([]) in the regular expression do not appear in pairs.

• Solution: Ensure that the parentheses are symmetric.

ORA-12727: invalid back reference in regular expression

• Error code in OceanBase Database: 5814

• SQLSTATE: HY000

• Cause: The subexpression contains a back reference.

• Solution: Make sure that the referenced subexpression is valid.

ORA-12728: invalid range in regular expression

• Error code in OceanBase Database: 5815

• SQLSTATE: HY000

• Cause: An invalid range is found in the regular expression.

• Solution: Ensure that a valid range is used.

ORA-12729: invalid character class in regular expression

• Error code in OceanBase Database: 5816

• SQLSTATE: HY000

• Cause: An unknown character class is found in the regular expression.

• Solution: Use a valid character class.

ORA-12731: invalid collation class in regular expression

• Error code in OceanBase Database: 5817

• SQLSTATE: HY000

• Cause: An unknown collation class is found in the regular expression.

• Solution: Use a valid collation class.

ORA-12801: error signaled in parallel query server

• Error code in OceanBase Database: 5736

• SQLSTATE: HY000

• Cause: When Parallel eXecution (PX) needs to be terminated, this error code is broadcasted to all execution nodes to terminate the current execution.

• Solution: Find the cause of interruption in the execution log or contact OceanBase Technical Support for troubleshooting.

ORA-12827: insufficient parallel query worker available

• Error code in OceanBase Database: 5345

• SQLSTATE: HY000

• Cause: The parallel_servers_target parameter is specified, but the number of obtained slaves is less than the specified lower limit or reaches the upper limit.

• Solution: Increase the value of parallel_servers_target and execute the query again, or wait for slaves to be released after some ongoing queries are completed.

ORA-12899: value too large for column '%.*s' at row %ld

• Error code in OceanBase Database: 5167

• SQLSTATE: 22001

• Cause: The column value to be inserted or updated exceeds the width limit.

• Solution: Check the correctness of the SQL statement. Check the data types of the source and destination columns. Increase the width of the destination column or use a subset, namely, a substring, of the source column.

ORA-12991: column is referenced in a multi-column constraint

• Error code in OceanBase Database: 5792

• SQLSTATE: HY000

• Cause: You attempted to delete a column referenced by some constraints.

• Solution: Delete all constraints that reference the column or specify CASCADE CONSTRAINTS in the statement.

ORA-12991: column \'%.*s\' is referenced in a multi-column constraint \'%.*s\'

• Error code in OceanBase Database: 5859

• SQLSTATE: HY000

• Cause: You attempted to delete a column referenced by some constraints.

• Solution: Delete all constraints that reference the column or specify CASCADE CONSTRAINTS in the statement.

ORA-12992: cannot drop parent key column

• Error code in OceanBase Database: 5793

• SQLSTATE: HY000

• Cause: You attempted to drop a parent key column.

• Solution: Delete all constraints that reference this parent key column, or specify CASCADE CONSTRAINTS in the statement.

ORA-13207: incorrect use of the ['%.*s'] operator

• Error code in OceanBase Database: 5804

• SQLSTATE: HY000

• Cause: An error occurred while using the specified operator.

• Solution: Check the parameters and return type of the operator.

ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE

• Error code in OceanBase Database: 5275

• SQLSTATE: HY000

• Cause: The partition bound list contains elements of invalid types. To be specific, the elements are not digits, null strings, datetime, interval literals, or MAXVALUE.

• Solution: Ensure that all elements in the partition bound list are of valid types.

ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE

• Error code in OceanBase Database: 5285

• SQLSTATE: HY000

• Cause: The partition bound list contains elements of invalid types. To be specific, the elements are not digits, null strings, datetime, interval literals, or MAXVALUE.

• Solution: Ensure that all elements in the partition bound list are of valid types.

ORA-14036: partition bound value too large for column

• Error code in OceanBase Database: 5354

• SQLSTATE: 22001

• Cause: The length of a partition bound value exceeds that of the corresponding partitioning column.

• Solution: Ensure that the upper bounds of partitions do not exceed the lengths of the corresponding partitioning columns.

ORA-14037: partition bound of partition '%.*s' is too high

• Error code in OceanBase Database: 5281

• SQLSTATE: HY000

• Cause: The upper bound of a partition is greater than that of the next partition.

• Solution: Ensure that the upper bound of each partition, except for the last partition, is less than that of the next partition.

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

• Error code in OceanBase Database: 5863

• SQLSTATE: HY000

• Cause: The ALTER TABLE or ALTER INDEX statement attempted to combine the RENAME operation with other operations, which is not allowed.

• Solution: Make sure that the ALTER TABLE or ALTER INDEX statement contains only the RENAME operation.

ORA-14060: data type or length of a table partitioning column may not be changed

• Error code in OceanBase Database: 5895

• SQLSTATE: HY000

• Cause: The ALTER TABLE statement is used to modify the data type or length of a partitioning column in a table named by using the ALTER TABLE statement.

• Solution: Do not modify the data type or length of partitioning columns in a table.

ORA-14074: partition bound must collate higher than that of the last partition

• Error code in OceanBase Database: 5353

• SQLSTATE: HY000

• Cause: The partition bound specified in the ALTER TABLE ADD PARTITION statement is not higher than the bound of the last partition in the table.

• Solution: Ensure that the bound of the partition to be added is higher than that of the last partition in the table.

ORA-14100: partition extended table name cannot refer to a remote object

• Error code in OceanBase Database: 5899

• SQLSTATE: HY000

• Cause: You attempted to name a remote object by using partition-extended table syntax.

• Solution: Correct the expression and retry.

ORA-14159: duplicate subpartition name

• Error code in OceanBase Database: 5867

• SQLSTATE: HY000

• Cause: The name of a subpartition of the table or index is not unique.

• Solution: Rename the subpartition to make sure that its name is unique among subpartitions of the table or index.

ORA-14170: cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX

• Error code in OceanBase Database: 5866

• SQLSTATE: HY000

• Cause: The request generates a default partition description (possibly through PARTITIONS number-of-partitions) and specifies the <(sub)partition-description> clause, which is not allowed.

• Solution: Delete one of the clauses.

ORA-14214: VALUES (<value list>) cannot be used for Range subpartitioned tables

• Error code in OceanBase Database: 5876

• SQLSTATE: HY000

• Cause: The VALUES (value list) clause is used for RANGE-subpartitioned tables.

• Solution: Use the VALUES LESS THAN or AT clause for RANGE-subpartitioned tables.

ORA-14217: VALUES (<value list>) clause expected

• Error code in OceanBase Database: 5877

• SQLSTATE: HY000

• Cause: The VALUES (value list) clause is not specified for a LIST-subpartitioned table.

• Solution: Specify the VALUES (value list) clause.

ORA-14251: Specified subpartition does not exist

• Error code in OceanBase Database: 5830

• SQLSTATE: HY000

• Cause: No subpartition is found for the object.

• Solution: Use the valid subpartition name and try again.

ORA-14253: table is not partitioned by composite partition method

• Error code in OceanBase Database: 5875

• SQLSTATE: HY000

• Cause: The possible causes are as follows:

  • The table in a subpartition maintenance operation, such as ALTER TABLE [EXCHANGE | MODIFY | MOVE | TRUNCATE] SUBPARTITION or ALTER TABLE MODIFY PARTITION [ADD | COALESCE] SUBPARTITION, is not partitioned by using the composite partitioning method.

  • The table in the MODIFY DEFAULT ATTRIBUTES FOR PARTITION operation is partitioned by using a method other than composite partitioning.

  • The table in the ALTER TABLE MODIFY SUBPARTITION [UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES] statement is not partitioned by using the composite partitioning method.

• Solution: Ensure that the table is partitioned by using the composite partitioning method.

ORA-14265: data type or length of a table subpartitioning column may not be changed

• Error code in OceanBase Database: 5896

• SQLSTATE: HY000

• Cause: The ALTER TABLE statement is used to modify the data type or length of a column used to partition a table named by using the ALTER TABLE statement.

• Solution: Do not modify the data type or length of table subpartitioning columns.

ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

• Error code in OceanBase Database: 5355

• SQLSTATE: HY000

• Cause: The partition bound list contains elements of invalid types, which are not digits, null strings, datetime, interval literals, or NULL.

• Solution: Ensure that all elements in the partition bound list are of valid types.

ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

• Error code in OceanBase Database: 5878

• SQLSTATE: HY000

• Cause: The VALUES LESS THAN or VALUES LESS AT clause can be used only for RANGE-partitioned tables.

• Solution: Use the VALUES (value list) clause for LIST-partitioned tables.

ORA-14311: Expecting VALUES LESS THAN or AT clause

• Error code in OceanBase Database: 5879

• SQLSTATE: HY000

• Cause: The VALUES (value list) clause can be used only for LIST-partitioned tables.

• Solution: Use the VALUES LESS THAN clause for RANGE-partitioned tables.

ORA-14312: invalid time limit specified

• Error code in OceanBase Database: 5882

• SQLSTATE: HY000

• Cause: A non-positive value is specified for the time parameter of the dbms_lock.sleep(time) package.

• Solution: Specify a positive value.

ORA-14400: inserted partition key does not map to any partition

• Error code in OceanBase Database: 5284

• SQLSTATE: HY000

• Cause:

  • You attempted to insert a record to a RANGE or COMPOSITE RANGE object, but the concatenated partitioning key included in the RANGE or COMPOSITE RANGE object is beyond the concatenated partition bound list of the last partition.

  • You attempted to insert a record to a LIST object, but the partitioning key included in this object does not match the specified literal value of any partition.

• Solution: Do not insert this key, add a partition that accepts this key, or add a value matching this key to the partition configuration.

ORA-14402: updating partition key column would cause a partition change

• Error code in OceanBase Database: 5350

• SQLSTATE: HY000

• Cause: The UPDATE operation caused a change of the partition to which the row belongs.

• Solution: Enable the enable row movement attribute for the table.

ORA-14501: object is not partitioned

• Error code in OceanBase Database: 5829

• SQLSTATE: HY000

• Cause: The table or index is not partitioned. The syntax is invalid.

• Solution: Retry the command with the valid syntax.

ORA-16000: standby cluster support weak read only

• Error code in OceanBase Database: 4688

• SQLSTATE: HY000

• Cause: You attempted to execute DDL or DML statements on the standby cluster, which supports only weak consistency reads.

• Solution: Switch the standby cluster to be the primary cluster.