ORA-30000 to ORA-49999

ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

• Error code in OceanBase Database: 5768

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function is called beyond the SELECT list and ORDER BY clause.

• Solution: Delete the calls of the SYS_CONNECT_BY_PATH function except those in the SELECT list and ORDER BY clause.

ORA-30003: illegal parameter in SYS_CONNECT_BY_PATH function

• Error code in OceanBase Database: 5769

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function contains invalid arguments.

ORA-30003: illegal parameter in SYS_CONNECT_BY_PATH function

• Error code in OceanBase Database: 5927

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function contains invalid arguments.

ORA-30004: A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values

• Error code in OceanBase Database: 5770

• SQLSTATE: HY000

• Cause: The string used by the SYS_CONNECT_BY_PATH function to separate column values is included in a column value.

• Solution: Specify another separator that is not included in any column value for the SYS_CONNECT_BY_PATH function, and try again.

ORA-30006: resource busy; acquire with WAIT timeout expired

• Error code in OceanBase Database: 6003

• SQLSTATE: HY000

• Cause: The requested resource is busy.

• Solution: Try again later.

ORA-30007: CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition

• Error code in OceanBase Database: 5771

• SQLSTATE: HY000

• Cause: You attempted to use the CONNECT BY ROOT operator in the START WITH or CONNECT BY condition.

• Solution: Delete the CONNECT BY ROOT operator from the START WITH or CONNECT BY condition.

ORA-30009: Not enough memory for CONNECT BY operation

• Error code in OceanBase Database: 5926

• SQLSTATE: HY000

• Cause: The memory size is insufficient for processing all levels of the hierarchy specified by the query.

• Solution: Set PGA_AGGREGATE_TARGET to a reasonable large value when WORKAREA_SIZE_POLICY is set to AUTO, or set SORT_AREA_SIZE to an appropriately large value when WORKAREA_SIZE_POLICY is set to MANUAL.

ORA-30076: invalid extract field for extract source

• Error code in OceanBase Database: 5686

• SQLSTATE: HY000

• Cause: The data extraction source does not contain the specified data extraction field.

ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

• Error code in OceanBase Database: 5349

• SQLSTATE: HY000

• Cause: The TIME or TIMESTAMP column does not contain TIME ZONE.

• Solution: Use the TIME or TIMESTAMP format with TIME ZONE.

ORA-30084: invalid data type for datetime primary with time zone modifier

• Error code in OceanBase Database: 5950

• SQLSTATE: HY000

• Cause: If a time zone modifier is specified, the value of the datetime parameter must be of the TIME, TIME WITH TIME ZONE, TIMESTAMP, or TIME STAMP WITH TIME ZONE type.

ORA-30088: datetime/interval precision is out of range

• Error code in OceanBase Database: 5605

• SQLSTATE: HY000

• Cause: The specified datetime or interval precision is not within the range of 0 to 9.

• Solution: Ensure that the datetime or interval precision is within the range of 0 to 9.

ORA-30175: invalid type given for an argument

• Error code in OceanBase Database: 5351

• SQLSTATE: HY000

• Cause: The argument list contains arguments of invalid types.

• Solution: Use correct data types for arguments.

ORA-30186: '\' must be followed by four hexdecimal characters or another '\'

• Error code in OceanBase Database: 5938

• SQLSTATE: HY000

• Cause: In the argument of the SQL function UNISTR, a pair of double backslashes (\\) must be followed by four hexadecimal characters or another pair of double backslashes (\\).

• Solution: Correct the string format.

ORA-30482: DISTINCT not allowed here

• Error code in OceanBase Database: 5798

• SQLSTATE: HY000

• Cause: The DISTINCT option is not allowed in the function.

ORA-30485: missing ORDER BY expression in the window specification

• Error code in OceanBase Database: 5300

• SQLSTATE: HY000

• Cause: The ORDER BY expression is missing from the window function or aggregation group.

ORA-30487: ORDER BY not allowed here

• Error code in OceanBase Database: 5797

• SQLSTATE: HY000

• Cause: The ORDER BY expression is not allowed in the DISTINCT function and RATIO_TO_REPORT.

ORA-30488: argument should be a function of expressions in PARTITION BY

• Error code in OceanBase Database: 5347

• SQLSTATE: HY000

• Cause: The argument of the window function must be a constant for a partition.

ORA-30493: The percentile value should be a number between 0 and 1.

• Error code in OceanBase Database: 5861

• SQLSTATE: HY000

• Cause: The percentile value specified for the PERCENTILE_CONT or PERCENTILE_DISC function is not within the specified range.

• Solution: Specify a value within the range of [0,1].

ORA-30494: The argument [%s] of WIDTH_BUCKET function is NULL or invalid.

• Error code in OceanBase Database: 5925

• SQLSTATE: HY000

• Cause: The [%s] argument of the WIDTH_BUCKET function is NULL or invalid.

ORA-30495: The argument should be of numeric or date/datetime type.

• Error code in OceanBase Database: 5862

• SQLSTATE: HY000

• Cause: The argument must be of the numeric or date/datetime type.

ORA-30496: Argument should be a constant.

• Error code in OceanBase Database: 5852

• SQLSTATE: HY000

• Cause: The argument value is not a constant.

ORA-30562: SAMPLE percentage must be in the range [0.000001,100)

• Error code in OceanBase Database: 5730

• SQLSTATE: HY000

• Cause: The SAMPLE percentage should be within the range of [0.000001,100).

ORA-30563: outer join operator (+) is not allowed here

• Error code in OceanBase Database: 5626

• SQLSTATE: HY000

• Cause: You attempted to reference + in the SELECT_LIST function or the CONNECT BY, START WITH, or ORDER BY clause.

• Solution: Do not use operators in the SELECT_LIST function or the CONNECT BY, START WITH, or ORDER BY clause.

ORA-30625: method dispatch on NULL SELF argument is disallowed

• Error code in OceanBase Database: 5847

• SQLSTATE: HY000

• Cause: A MEMBER method is called by the NULL SELF argument.

• Solution: Change the method call type so that a valid SELF argument is passed.

ORA-30665: invalid NOT NULL constraint specified on a DEFAULT ON NULL column

• Error code in OceanBase Database: 5949

• SQLSTATE: HY000

• Cause: The NOT NULL constraint is not correctly specified on the DEFAULT ON NULL column.

• Solution: If the NOT NULL constraint is specified on the DEFAULT ON NULL column, enable the constraint immediately.

ORA-30669: table can have only one identity column

• Error code in OceanBase Database: 5909

• SQLSTATE: HY000

• Cause: The operation attempted to specify multiple identity columns for a table.

• Solution: Specify only one identity column for each table.

ORA-30670: invalid NOT NULL constraint specified on an identity column

• Error code in OceanBase Database: 5910

• SQLSTATE: HY000

• Cause: The NOT NULL constraint is not properly specified on the identity column.

• Solution: If the NOT NULL constraint is specified for the identity column, enable the constraint immediately.

ORA-30671: cannot modify NOT NULL constraint on an identity column

• Error code in OceanBase Database: 5911

• SQLSTATE: HY000

• Cause: The NOT NULL constraint on the identity column cannot be modified.

• Solution: Do not modify the NOT NULL constraint on an identity column.

ORA-30672: cannot drop NOT NULL constraint on an identity column

• Error code in OceanBase Database: 5912

• SQLSTATE: HY000

• Cause: The NOT NULL constraint on the identity column cannot be deleted.

• Solution: Do not delete the NOT NULL constraint from the identity column. To delete the constraint, call the DROP IDENTITY operation in the ALTER TABLE MODIFY statement to delete the identity attribute of the column.

ORA-30673: column to be modified is not an identity column

• Error code in OceanBase Database: 5913

• SQLSTATE: HY000

• Cause: The operation attempted to modify the identity attribute of a non-identity column.

• Solution: Modify the identity attribute of only an identity column.

ORA-30674: identity column cannot have a default value

• Error code in OceanBase Database: 5914

• SQLSTATE: HY000

• Cause: The operation attempted to add a default value to an identity column.

• Solution: Do not specify a default value for an identity column.

ORA-30675: identity column must be a numeric type

• Error code in OceanBase Database: 5915

• SQLSTATE: HY000

• Cause: The operation attempted to create non-numeric values for an identity column or change the values of an identity column into non-numeric values.

• Solution: Do not assign a non-numeric data type to an identity column.

ORA-30926: unable to get a stable set of rows in the source tables

• Error code in OceanBase Database: 30926

• SQLSTATE: HY000

• Cause: A stable set of rows cannot be obtained due to a large DML activity or a non-deterministic WHERE clause.

• Solution: Delete the non-deterministic WHERE clause and re-execute the DML statement.

ORA-30929: ORDER SIBLINGS BY clause not allowed here

• Error code in OceanBase Database: 5325

• SQLSTATE: HY000

• Cause: The specified query with the ORDER SIBLINGS BY clause does not contain the CONNECT BY clause.

• Solution: Delete the ORDER SIBLINGS BY clause or add the CONNECT BY clause to the query.

ORA-30929: ORDER SIBLINGS BY clause not allowed here

• Error code in OceanBase Database: 5772

• SQLSTATE: HY000

• Cause: The specified query with the ORDER SIBLINGS BY clause does not contain the CONNECT BY clause.

• Solution: Delete the ORDER SIBLINGS BY clause or add the CONNECT BY clause to the query.

ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column

• Error code in OceanBase Database: 5773

• SQLSTATE: HY000

• Cause: CONNECT_BY_ISCYCLE is specified in a query, but this query does not contain the NOCYCLE keyword.

• Solution: Delete CONNECT_BY_ISCYCLE from the query or add the NOCYCLE keyword to the query.

ORA-31011: XML parsing failed

• Error code in OceanBase Database: 7401
• SQLSTATE: 42000
• Cause: An error occurred when the XML parser attempted to parse a document.
• Solution: Check whether the document is valid.

ORA-31011: XML parsing failed

• Error code in OceanBase Database: 9549

• SQLSTATE: HY000

• Cause: The XML parser returns an error when it parses a document.

• Solution: Check whether the document to be parsed is valid.

ORA-31600: invalid input value %.*s for parameter %.*s in function %.*s

• Error code in OceanBase Database: 9504

• SQLSTATE: HY000

• Cause: The input parameter value is NULL or invalid.

• Solution: Specify a valid value and call the function again.

ORA-31603: object '%.*s' of type %.*s not found in schema '%.*s'

• Error code in OceanBase Database: 9503

• SQLSTATE: HY000

• Cause: The specified object cannot be found in the database.

• Solution: Modify the object configuration and try again.

ORA-32021: parameter value longer than %d characters

• Error code in OceanBase Database: 5939

• SQLSTATE: HY000

• Cause: The parameter value exceeds the maximum length, or one of the parameter values in the parameter list exceeds the maximum value.

• Solution: Reduce the length of the parameter value and try again. For the DISPATCHERS parameter, use a listener alias to reduce the value length.

ORA-32031: illegal reference of a query name in WITH clause

• Error code in OceanBase Database: 5737

• SQLSTATE: HY000

• Cause: Forward or recursive reference of a query name in the WITH clause is not allowed.

• Solution: Modify the query statement and try again.

ORA-32033: unsupported column aliasing

• Error code in OceanBase Database: 5738

• SQLSTATE: HY000

• Cause: The WITH clause does not support column aliases.

• Solution: Specify an alias in the subquery and try again.

ORA-32034: unsupported use of WITH clause

• Error code in OceanBase Database: 5739

• SQLSTATE: HY000

• Cause: The WITH clause is used improperly in either of the following ways:

  • A WITH clause is nested in another WITH clause.

  • In a set query, a WITH clause is specified for branches.

• Solution: Modify the query and try again.

ORA-32038: number of WITH clause column names does not match number of elements in select list

• Error code in OceanBase Database: 5740

• SQLSTATE: HY000

• Cause: A column alias or name list is specified for a WITH query name, but the number of elements in the list does not match the number of elements in the SELECT list of the definition query.

• Solution: Update the column alias list or SELECT list to ensure that they have the same number of elements.

ORA-32039: recursive WITH clause must have column alias list

• Error code in OceanBase Database: 5741

• SQLSTATE: HY000

• Cause: A WITH query recursively references itself, but no column alias list is specified for this query.

• Solution: Add a column alias list for the WITH query name.

ORA-32040: recursive WITH clause must use a UNION ALL operation

• Error code in OceanBase Database: 5742

• SQLSTATE: HY000

• Cause: A WITH query recursively references itself, but the UNION ALL operation is not used in the definition query.

• Solution: Rewrite the recursive WITH query so that the UNION ALL operation is used.

ORA-32041: UNION ALL operation in recursive WITH clause must have only two branches

• Error code in OceanBase Database: 5743

• SQLSTATE: HY000

• Cause: A WITH query recursively references itself but uses a UNION ALL operation with more than two branches, which is not supported.

• Solution: Rewrite the recursive WITH query so that it uses only two branches in the UNION ALL operation.

ORA-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches

• Error code in OceanBase Database: 5744

• SQLSTATE: HY000

• Cause: A WITH query recursively references itself indirectly. For example, it does so through a subquery or view.

• Solution: Rewrite the recursive WITH query so that it directly references itself in the FROM clause of a branch of the UNION ALL operation.

ORA-32043: recursive WITH clause needs an initialization branch

• Error code in OceanBase Database: 5745

• SQLSTATE: HY000

• Cause: A WITH query recursively references itself, but an initial branch that does not reference itself is absent in the UNION ALL operation.

• Solution: Rewrite the WITH query by adding an initial branch that does not reference itself to the UNION ALL operation.

ORA-32044: cycle detected while executing recursive WITH query

• Error code in OceanBase Database: 5746

• SQLSTATE: HY000

• Cause: A recursive WITH query forms a cycle, and the system stops this query to avoid an infinite cycle.

• Solution: Rewrite the recursive WITH query to stop the recursion, or use the CYCLE clause in the query.

ORA-32045: maximum level of recursion reached while executing recursive WITH query

• Error code in OceanBase Database: 5747

• SQLSTATE: HY000

• Cause: A recursive WITH query reaches the specified maximum recursion level and stops.

• Solution: Increase the maximum recursion level or use the CYCLE clause.

ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list

• Error code in OceanBase Database: 5748

• SQLSTATE: HY000

• Cause: The SEARCH clause in a recursive WITH query specifies a sequence column, but this sequence column already exists in the column alias list of the WITH query.

• Solution: Specify a different name for the sequence column in the SEARCH clause, or delete this name from the column alias list.

ORA-32047: cycle mark value and non-cycle mark value must be one byte character string values

• Error code in OceanBase Database: 5749

• SQLSTATE: HY000

• Cause: The cycle mark or non-cycle mark value specified in the CYCLE clause of a recursive WITH query is not a one-byte string.

• Solution: Specify a one-byte string as the value of cycle mark or non-cycle mark in the CYCLE clause of the recursive WITH query.

ORA-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

• Error code in OceanBase Database: 5750

• SQLSTATE: HY000

• Cause: The CYCLE clause in a recursive WITH query specifies a cycle mark column, but this column already exists in the column alias list of the WITH query.

• Solution: Specify a different name for the cycle mark column in the CYCLE clause, or delete this name from the column alias list.

ORA-32049: duplicate name found in column alias list for WITH clause

• Error code in OceanBase Database: 5751

• SQLSTATE: HY000

• Cause: A name appears multiple times in the column alias list of the WITH clause.

• Solution: Delete duplicate names from the column alias list.

ORA-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements

• Error code in OceanBase Database: 5752

• SQLSTATE: HY000

• Cause: The SEARCH or CYCLE clause is specified for a non-recursive WITH clause element.

• Solution: Delete the SEARCH or CYCLE clause, or add recursion to the WITH clause element.

ORA-32481: cycle value for CYCLE clause must be different from the non-cycle value

• Error code in OceanBase Database: 5753

• SQLSTATE: HY000

• Cause: The CYCLE clause is specified for a recursive WITH query, but the cycle value is the same as a non-cycle value or the DEFAULT value.

• Solution: Change the cycle value or the non-cycle value to ensure that they are different.

ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

• Error code in OceanBase Database: 5754

• SQLSTATE: HY000

• Cause: The SEARCH and CYCLE clauses are specified for a recursive WITH query, but the sequence column of the SEARCH clause is the same as the cycle mark column of the CYCLE clause.

• Solution: Modify the sequence or cycle mark column to ensure that they are different.

ORA-32483: duplicate name found in sort specification list for SEARCH clause of WITH clause

• Error code in OceanBase Database: 5755

• SQLSTATE: HY000

• Cause: A SEARCH clause is specified for a recursive query, but the sort specification list in the recursive query contains duplicate names.

• Solution: Delete duplicate names from the sort specification list.

ORA-32484: duplicate name found in cycle column list for CYCLE clause of WITH clause

• Error code in OceanBase Database: 5756

• SQLSTATE: HY000

• Cause: A CYCLE clause is specified for a recursive query, but the cycle column list of the CYCLE clause contains duplicate names.

• Solution: Delete duplicate names from the cycle column list of the CYCLE clause.

ORA-32485: element in cycle column list of CYCLE clause must appear in the column alias list of the WITH clause element

• Error code in OceanBase Database: 5757

• SQLSTATE: HY000

• Cause: In the CYCLE clause specified for a recursive WITH query, the elements in the cycle column list are not included in the column alias list of the WITH clause element.

• Solution: Modify the cycle column list so that only the names included in the column alias list of the WITH clause element are used.

ORA-32486: unsupported operation in recursive branch of recursive WITH clause

• Error code in OceanBase Database: 5758

• SQLSTATE: HY000

• Cause: The recursive component of the UNION ALL operation in a recursive WITH clause element uses an unsupported operation. The recursive branch of the UNION ALL operation must not use GROUP BY, DISTINCT, MODEL, grouping sets, CONNECY BY, window functions, HAVING, or aggregate functions.

• Solution: Rewrite the query and ensure that it does not contain unsupported operations.

ORA-32487: unsupported join in recursive WITH query

• Error code in OceanBase Database: 5759

• SQLSTATE: HY000

• Cause: The recursive component in the recursive WITH clause element contains the following unsupported join operations:

  • A LEFT OUTER join with the name of the recursive query on the right side

  • A RIGHT OUTER join with the name of the recursive query on the left side

  • A FULL OUTER join that involves the name of the recursive query

• Solution: Rewrite the query and ensure that it does not contain unsupported join operations.

ORA-32488: WITH clause element did not have a column alias list

• Error code in OceanBase Database: 5760

• SQLSTATE: HY000

• Cause: A WITH clause element uses the SEARCH clause and/or the CYCLE clause but does not specify a column alias list for them.

• Solution: Add a column alias list for the WITH query name.

ORA-32489: element in sort specification list of SEARCH clause did not appear in the column alias list of the WITH clause element

• Error code in OceanBase Database: 5761

• SQLSTATE: HY000

• Cause: The elements in the sort specification list of the SEARCH clause specified for a recursive WITH query are not included in the column alias list of the WITH clause element.

• Solution: Modify the sort specification list so that only the names in the column alias list of the WITH clause element are used.

ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element

• Error code in OceanBase Database: 5762

• SQLSTATE: HY000

• Cause: The recursive component of the UNION ALL operation in a recursive WITH clause element references the name of the recursive query multiple times. The recursive branch of the recursive WITH query can reference the name of the recursive query only once.

• Solution: Rewrite the query so that its recursive branch references the name of the query only once.

ORA-32595: DDL statement cannot be audited with BY SESSION specified

• Error code in OceanBase Database: 4364

• SQLSTATE: HY000

• Cause: You attempted to audit a DDL statement with a specified BY SESSION clause. DDL statements can be audited only by using BY ACCESS.

• Solution: Use BY ACCESS to audit the DDL statement.

ORA-32792: prebuilt table managed column cannot be an identity column

• Error code in OceanBase Database: 5916

• SQLSTATE: HY000

• Cause: The operation attempted to create an instantiated view on a pre-built table with an identity column.

• Solution: Delete the identity attribute or delete the identity column from the instantiated view.

ORA-32793: cannot alter a system-generated sequence

• Error code in OceanBase Database: 5917

• SQLSTATE: HY000

• Cause: The operation attempted to modify a system-generated sequence.

• Solution: Do not modify sequences generated by the system, such as a sequence created for the identity column.

ORA-32794: cannot drop a system-generated sequence

• Error code in OceanBase Database: 5918

• SQLSTATE: HY000

• Cause: The operation attempted to drop a system-generated sequence.

• Solution: Do not drop sequences generated by the system, for example, a sequence created for the identity column.

ORA-32795: cannot insert into a generated always identity column

• Error code in OceanBase Database: 5919

• SQLSTATE: HY000

• Cause: The operation attempted to insert a value into an identity column created by using the GENERATED ALWAYS keyword.

• Solution: Do not directly insert a value into an identity column that is created by using the GENERATED ALWAYS keyword. Instead, the value should be provided by the associated sequence generator.

ORA-32796: cannot update a generated always identity column

• Error code in OceanBase Database: 5920

• SQLSTATE: HY000

• Cause: The operation attempted to update an identity column created by using the GENERATED ALWAYS keyword.

• Solution: Do not directly update an identity column that is created by using the GENERATED ALWAYS keyword.

ORA-32797: identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION

• Error code in OceanBase Database: 5921

• SQLSTATE: HY000

• Cause: Sequences of identity columns of two tables specified in the EXCHANGE statement are neither incremented nor decremented.

• Solution: Ensure that the sequences of the identity columns with INCREMENT BY have the same symbol.

ORA-32798: cannot rename a system-generated sequence

• Error code in OceanBase Database: 5922

• SQLSTATE: HY000

• Cause: The operation attempted to rename a system-generated sequence.

• Solution: Do not rename sequences generated by the system, such as a sequence created for the identity column.

ORA-38101: Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'

• Error code in OceanBase Database: 5803

• SQLSTATE: HY000

• Cause: The INSERT VALUES clause references an invalid table column.

ORA-38104: Columns referenced in the ON Clause cannot be updated:'%.*s'.'%.*s'

• Error code in OceanBase Database: 38104

• SQLSTATE: HY000

• Cause: LHS in UPDATE SET contains columns referenced in the ON clause.

ORA-38778: Restore point %s already exists

• Error codes in OceanBase Database: 6259 and 6261

• SQLSTATE: HY000

• Cause: The restore point name in the CREATE RESTORE POINT statement already exists. The restore point name must be unique.

• Solution: Specify another name or delete the existing restore point with the same name.

ORA-38779: cannot create restore point - too many restore points

• Error code in OceanBase Database: 6263

• SQLSTATE: HY000

• Cause: The number of created restore points has reached the maximum number allowed.

• Solution: Delete some existing restore points and try again.

ORA-38780: Restore point %s does not exists

• Error code in OceanBase Database: 6260 and 6262

• SQLSTATE: HY000

• Cause: The restore point name specified in the statement does not exist.

• Solution: Query the restore point table for the restore point.

ORA-39962: invalid parameter for PLSQL_CCFLAGS

• Error code in OceanBase Database: 5940

• SQLSTATE: HY000

• Cause: The value of the PLSQL_CCFLAGS parameter is invalid.

• Solution: Specify a valid value for the PLSQL_CCFLAGS parameter.

ORA-42399: cannot perform a DML operation on a read-only view

• Error code in OceanBase Database: 5723

• SQLSTATE: HY000

• Cause: You attempted to insert, delete, or update rows in a read-only view, which is not allowed.

• Solution: Execute required DML operations on the base table of the view, or use the ALTER VIEW ... READ WRITE statement to make the view operable.