ORA-50000 to ORA-99999

ORA-54002: Only pure functions can be specified in a virtual column expression

• OceanBase error code: 5906

• SQLSTATE: HY000

• Cause: The virtual column expression contains an uncertain function.

• Solution: Rewrite the expression so that it contains only pure functions.

ORA-54003: specified data type is not supported for a virtual column

• OceanBase error code: 5893

• SQLSTATE: HY000

• Cause: Virtual columns support only scalar data types. The data types of LONG, BLOB, REF, and BFILE are not supported.

• Solution: Specify a supported scalar data type for the expression.

ORA-54004: The resultant data type of the virtual column is not supported

• OceanBase error code: 5401

• SQLSTATE: HY000

• Cause: The data type of the base expression is not supported. The virtual column supports only scalar data types. The data types of LONG, BLOB, REF, and BFILE are not supported.

• Solution: Specify a supported scalar data type for the expression.

ORA-54013: INSERT operation disallowed on virtual columns

• OceanBase error code: 5290

• SQLSTATE: HY000

• Cause: You are trying to insert a value into a virtual column.

• Solution: Execute the statement again without providing a value for the virtual column.

ORA-54016: Invalid column expression was specified

• OceanBase error code: 5908

• SQLSTATE: HY000

• Cause: The virtual column expression is not a valid arithmetic expression. It may reference another column in the table.

• Solution: Rewrite the virtual column expression.

ORA-54017: UPDATE operation disallowed on virtual columns

• OceanBase error code: 5907

• SQLSTATE: HY000

• Cause: You are trying to update the value of a virtual column.

• Solution: Execute the statement again without setting a value for the virtual column.

ORA-54021: Cannot use PL/SQL expressions in partitioning or subpartitioning columns

• OceanBase error code: 5995

• SQLSTATE: HY000

• Cause: The table is partitioned on a virtual column that contains PL/SQL expressions.

ORA-54023: Virtual column expression cannot be changed because a constraint is defined on column

• OceanBase error code: 5948

• SQLSTATE: HY000

• Cause: Modifying the value of a virtual column is not allowed in the trigger body.

• Solution: Do not modify the value of a virtual column in the trigger.

ORA-54025: A virtual column cannot have a default value

• OceanBase error code: 5504
• SQLSTATE: HY000
• Cause: A virtual column cannot have a default value.
• Solution: Drop the default value from the virtual column.

ORA-54026: A real column cannot have an expression

• OceanBase error code: 5505
• SQLSTATE: HY000
• Cause: An expression is not supported for a real column.
• Solution: Drop the expression from the real column.

ORA-54027: cannot modify data-type of virtual column

• OceanBase error code: 5506
• SQLSTATE: HY000
• Cause: You cannot modify the data type of a virtual column.

ORA-54029: Virtual column cannot be updated in trigger body

• OceanBase error code: 5703

• SQLSTATE: HY000

• Cause: You attempted to change the value of a virtual column in the trigger body.

• Solution: This operation is invalid. Change the trigger definition.

ORA-54036: cannot define referential constraint with ON DELETE SET NULL clause on virtual column

• OceanBase error code: 5513
• SQLSTATE: HY000
• Cause: You cannot define a foreign key constraint on a virtual column with the ON DELETE SET NULL clause.
• Solution: Do not define a foreign key constraint on a virtual column with the ON DELETE SET NULL clause.

ORA-54037: table must have at least 1 column that is not virtual

• OceanBase error code: 5904

• SQLSTATE: 42000

• Cause: You attempted to create a table that contains only virtual columns.

• Solution: Add at least one non-virtual column to the table.

ORA-54039: table must have at least one column that is not invisible

• OceanBase error code: 5679

• SQLSTATE: HY000

• Cause: You attempted to create or modify a table to contain only invisible columns.

• Solution: Add at least one visible column to the table.

ORA-54042: Invisible column is not supported on this type of table

• OceanBase error code: 5680

• SQLSTATE: HY000

• Cause: You attempted to create an invisible column or modify the visibility of a column, but the current table does not support invisible columns. Only heap tables and index-organized tables (IOT) support invisible columns.

• Solution: Do not support these columns. Modify the DDL.

ORA-54046: Column visibility modifications cannot be combined with any other modified column DDL option

• OceanBase error code: 5681

• SQLSTATE: HY000

• Cause: You attempted to combine the modification of column visibility with other column attribute modifications in one DDL statement.

• Solution: Perform the column visibility modification in a separate DDL statement.

ORA-54048: Column expression modifications cannot be combined with any other column DDL operation

• OceanBase error code: 5947

• SQLSTATE: HY000

• Cause: You attempted to modify a column expression together with other column operations.

• Solution: Modify the column expression in a separate DDL statement.

ORA-54053: The visibility of a column from a table owned by a SYS user cannot be changed

• OceanBase error code: 5682

• SQLSTATE: HY000

• Cause: You attempted to modify the visibility of a column in a table owned by the SYS user.

• Solution: Perform the DDL operation on a table owned by a non-SYS user.

ORA-56901: non-constant expression is not allowed for pivot|unpivot values

• OceanBase error code: 5805

• SQLSTATE: HY000

• Cause: A non-constant expression was used for the pivot|unpivot values.

• Solution: Use a constant expression for the pivot|unpivot values.

ORA-56902: expect aggregate function inside pivot operation

• OceanBase error code: 5806

• SQLSTATE: HY000

• Cause: A non-aggregate expression was used in the pivot operation.

• Solution: Use an aggregate expression.

ORA-56713: insufficient Resource Manager privileges

• OceanBase error code: 4715

• SQLSTATE: HY000

• Cause: You do not have the privilege to operate on the Resource Manager.

• Solution: Perform the operation as the root user.

ORA-62550: Invalid SQL ROW LIMITING expression was specified

• OceanBase error code: 5831

• SQLSTATE: HY000

• Cause: The ROW LIMITING expression in the SQL query statement contains components other than text, bind variables, related variables, and subqueries.

• Solution: Modify the ROW LIMITING expression in the SQL query statement and retry the operation.

ORA-64601: duplicate RESTART specified

• OceanBase error code: 4382

• SQLSTATE: HY000

• Cause: The ALTER SEQUENCE statement contains duplicate RESTART instructions.

• Solution: Remove the duplicate RESTART instructions.

ORA-64403: Input cannot be null

• OceanBase error code: 5471
• SQLSTATE: 42000
• Cause: The input cannot be null.
• Solution: Provide the input parameter.

ORA-00600: locality do not exist in locality list. can not set:

• OceanBase error code: 9133

• SQLSTATE: HY000

• Cause: The source of the backup path or archive path you specified does not exist.

• Solution: Query the DBA_OB_ZONES view to verify whether the locality you entered exists. If it does not exist, correct the locality and try again.