95 ORA-54000 to ORA-54056
- ORA-54000: Virtual column feature not yet implemented
-
Cause: Feature has not been implemented.
- ORA-54001: string: invalid identifier specified for virtual column expression
-
Cause: Column expression referenced a column that does not exist in the table.
- ORA-54002: only pure functions can be specified in a virtual column expression
-
Cause: Column expression contained a function whose evaluation is non-deterministic.
- ORA-54003: specified data type is not supported for a virtual column
-
Cause: Only scalar data types are supported for virtual columns. LONG, BLOB, REF, and BFILE data types are not supported for virtual columns.
- ORA-54004: resultant data type of virtual column is not supported
-
Cause: The data type of the underlying expression is not supported. Only scalar data types are supported for virtual columns. LONG, BLOB, REF, and BFILE data types are not supported for virtual columns.
- ORA-54005: keyword VIRTUAL cannot be specified here
-
Cause: The keyword VIRTUAL was either repeated or incorrectly specified.
- ORA-54006: keyword VISIBLE cannot be specified here
-
Cause: The keyword VISIBLE was either repeated or incorrectly specified.
- ORA-54007: keyword HIDDEN cannot be specified here
-
Cause: The keyword HIDDEN was either repeated or incorrectly specified.
- ORA-54008: expression column is not supported for an index organized table
-
Cause: Attempt to create/alter an index organized table with an expression column
- ORA-54009: expression column is not supported for an external table
-
Cause: Attempt to create/alter an external table with an expression column
- ORA-54010: expression column is not supported for a temporary table
-
Cause: Attempt to create/alter a temporary table with an expression column
- ORA-54011: expression column is not supported for a clustered table
-
Cause: Attempt to create/alter a clustered table with an expression column
- ORA-54012: virtual column is referenced in a column expression
-
Cause: This virtual column was referenced in an expression of another virtual column
- ORA-54013: INSERT operation disallowed on virtual columns
-
Cause: Attempted to insert values into a virtual column
- ORA-54014: Resulting table from a CTAS operation contains virtual column(s)
-
Cause: Table being created by a CTAS operation contains a virtual column definition
- ORA-54015: Duplicate column expression was specified
-
Cause: Expression of the virtual column being added/created conflicts with an existing/previously specified functional index expression or virtual column expression
- ORA-54016: Invalid column expression was specified
-
Cause: Virtual column expression is not a valid arithmetic expression. it probably refers to another column in the table
- ORA-54017: UPDATE operation disallowed on virtual columns
-
Cause: Attempted to update values of a virtual column
- ORA-54018: A virtual column exists for this expression
-
Cause: Specified index expression matches an existing virtual column"
- ORA-54019: Virtual column expression cannot be changed because it is a partitioning column
-
Cause: Attempted to modify the expression of a virtual column that was also a partitioning column.
- ORA-54020: Virtual column expression cannot be changed because it is a subpartitioning column
-
Cause: Attempted to modify the expression of a virtual column that was also a subpartitioning column.
- ORA-54021: Cannot use PL/SQL expressions in partitioning or subpartitioning columns
-
Cause: Attempted to partition a table on a virtual column that contained PL/SQL expressions.
- ORA-54022: Virtual column expression cannot be changed because an index is defined on column
-
Cause: Attempted to change the expression of a virtual column that was indexed.
- ORA-54023: Virtual column expression cannot be changed because a constraint is defined on column
-
Cause: Attempted to change the expression of a virtual column that had a constraint defined on it.
- ORA-54024: expression column is not supported for an organization cube table
-
Cause: Attempted to create or alter an organization cube table with an expression column
- ORA-54025: Virtual column cannot have a default value
-
Cause: Attempted to alter a virtual column to have a default value.
- ORA-54026: Real column cannot have an expression
-
Cause: Attempted to alter a real column to have an expression.
- ORA-54027: cannot modify data-type of virtual column
-
Cause: Attempted to change the data-type of virtual column without modifying the underlying expression
- ORA-54028: cannot change the HIDDEN/VISIBLE property of a virtual column
-
Cause: Attempted to change the HIDDEN/VIRTUAL property of a virtual column
- ORA-54029: Virtual column cannot be updated in trigger body
-
Cause: Attempted to change the value of virtual column in a trigger body"
- ORA-54030: datatype mismatch between virtual column and expression
-
Cause: virtual column expression was changed after column was created"
- ORA-54031: column to be dropped or modified is used in a virtual column expression
-
Cause: Attempted to drop or modify a column that was used in a virtual column expression.
- ORA-54032: column to be renamed is used in a virtual column expression
-
Cause: Attempted to rename a column that was used in a virtual column expression.
- ORA-54033: column to be modified is used in a virtual column expression
-
Cause: Attempted to modify the data type of a column that was used in a virtual column expression.
- ORA-54034: virtual columns not allowed in functional index expressions
-
Cause: An attempt was made to create a functional index with an expression defined on one or more virtual columns.
- ORA-54035: keyword HIDDEN cannot be specified here
-
Cause: Attempted to specify HIDDEN key word for a virtual column
- ORA-54036: cannot define referential constraint with ON DELETE SET NULL clause on virtual column
-
Cause: Attempted to specify ON DELETE SET NULL clause for a referential integrity constraint on a virtual column.
- ORA-54037: table must have at least 1 column that is not virtual
-
Cause: An attempt was made to create a table with only virtual columns.
- ORA-54038: Virtual column cannot be encrypted
-
Cause: An attempt was made to create or alter a virtual column to have encryption.
- ORA-54039: table must have at least one column that is not invisible
-
Cause: An attempt was made to create or alter a table to have only invisible columns.
- ORA-54040: Visibility of a system-generated column cannot be changed.
-
Cause: An attempt was made to alter the visibility of a system-generated column.
- ORA-54041: Visibility of an abstract data type column cannot be changed.
-
Cause: An attempt was made to alter the visibility of an abstract data type column.
- ORA-54042: Invisible column is not supported on this type of table.
-
Cause: An attempt was made to create or alter the visibility of a column on an unsupported table type. Invisible columns are only supported for heap and index-organized tables (IOT).
- ORA-54043: Including column of an IOT cannot be an invisible column.
-
Cause: An attempt was made to alter the visibility of the included column of an index-organized table (IOT).
- ORA-54044: Visibility of a column having a column-level object privilege cannot be changed.
-
Cause: An attempt was made to alter the visibility of a column with a column-level object privilege.
- ORA-54045: An invisible column cannot be granted a column-level object privilege.
-
Cause: An attempt was made to grant a column-level object privilege to an invisible column.
- ORA-54046: Column visibility modifications cannot be combined with any other modified column DDL option.
-
Cause: An attempt was made to combine the modification of the visibility of a column with other modified column property changes.
- ORA-54047: virtual columns not allowed for XMLType tables with object-relational storage
-
Cause: An attempt was made to create an object-relational XMLType table with virtual columns.
- ORA-54048: Column expression modifications cannot be combined with any other column DDL operation.
-
Cause: An attempt was made to combine the modification of the expression of a column with other column operations.
- ORA-54049: expression edition column is not supported for an external table
-
Cause: An attempt was made to create or alter an external table with an edition expression column.
- ORA-54050: Unsupported type or attribute on redacted column.
-
Cause: An attempt was made to alter a column with a redaction policy, so as to give that column an unsupported type or attribute. Virtual columns are not supported by data redaction. Columns with the INVISIBLE attribute are not supported by data redaction (this applies to both user-specified hidden columns and system-generated hidden columns). Vector encoded columns are not supported by data redaction.
- ORA-54051: System-generated virtual column cannot be a primary key.
-
Cause: An attempt was made to specify a system-generated virtual column * as a primary key.
- ORA-54052: System-generated functional index virtual column cannot be renamed.
-
Cause: An attempt was made to rename a system-generated functional index virtual column.
- ORA-54053: The visibility of a column from a table owned by a SYS user cannot be changed.
-
Cause: An attempt was made to alter the visibility of a column from a table owned by SYS user.
- ORA-54054: System-generated virtual column or guard column cannot be in a constraint.
-
Cause: An attempt was made to add a constraint containing the system generated virtual column or guard column.
- ORA-54055: In-Memory virtual column expression cannot refer to a system-generated or hidden column.
-
Cause: An attempt was made to create a virtual column expression on a system-generated or hidden column.
- ORA-54056: unsupported operation on sensitive column
-
Cause: An attempt was made to either alter the visibility of a sensitive column or change the sensitive column to vector encode.