96 ORA-54000 to ORA-54058

ORA-54000: Virtual column feature not yet implemented

Cause: Feature has not been implemented.

Action: Feature is being implemented.

ORA-54001: string: invalid identifier specified for virtual column expression

Cause: Column expression referenced a column that does not exist in the table.

Action: Rewrite column expression to reference only scalar columns 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.

Action: Rewrite column expression to reference only pure functions.

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.

Action: Specify the expression column with a supported scalar data type.

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.

Action: Specify the expression of virtual column to return a supported scalar data type.

ORA-54005: keyword VIRTUAL cannot be specified here

Cause: The keyword VIRTUAL was either repeated or incorrectly specified.

Action: Remove the keyword from the specified syntax.

ORA-54006: keyword VISIBLE cannot be specified here

Cause: The keyword VISIBLE was either repeated or incorrectly specified.

Action: Remove the keyword from the specified syntax.

ORA-54007: keyword HIDDEN cannot be specified here

Cause: The keyword HIDDEN was either repeated or incorrectly specified.

Action: Remove the keyword from the specified syntax.

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

Action: These columns are not supported, change the DDL.

ORA-54009: expression column is not supported for an external table

Cause: Attempt to create/alter an external table with an expression column

Action: These columns are not supported, change the DDL.

ORA-54010: expression column is not supported for a temporary table

Cause: Attempt to create/alter a temporary table with an expression column

Action: These columns are not supported, change the DDL.

ORA-54011: expression column is not supported for a clustered table

Cause: Attempt to create/alter a clustered table with an expression column

Action: These columns are not supported, change the DDL.

ORA-54012: virtual column is referenced in a column expression

Cause: This virtual column was referenced in an expression of another virtual column

Action: Ensure the column expression definition for any virtual column does not refer to any virtual column

ORA-54013: INSERT operation disallowed on virtual columns

Cause: Attempted to insert values into a virtual column

Action: Re-issue the statement without providing values for 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

Action: Remove the virtual column definition from the table being created

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

Action: Change the expression of the virtual column os there are no duplicate expressions

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

Action: Change the expression of the virtual column

ORA-54017: UPDATE operation disallowed on virtual columns

Cause: Attempted to update values of a virtual column

Action: Re-issue the statement without setting values for the virtual column

ORA-54018: A virtual column exists for this expression

Cause: Specified index expression matches an existing virtual column"

Action: Re-issue the statement by replacing the index expression with the matching 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.

Action: This is not supported.

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.

Action: This is not supported.

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.

Action: This is not supported.

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.

Action: Drop the index and then change the expression.

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.

Action: Drop constraint and then change expression.

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

Action: These columns are not supported, change the DDL.

ORA-54025: Virtual column cannot have a default value

Cause: Attempted to alter a virtual column to have a default value.

Action: This is not valid, change the DDL.

ORA-54026: Real column cannot have an expression

Cause: Attempted to alter a real column to have an expression.

Action: This is not valid, change the DDL.

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

Cause: Attempted to change the data-type of virtual column without modifying the underlying expression

Action: change the underlying expression to be compatible with the data-type change

ORA-54028: cannot change the HIDDEN/VISIBLE property of a virtual column

Cause: Attempted to change the HIDDEN/VIRTUAL property of a virtual column

Action: re-issue the DDL without the virtual column property change

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

Cause: Attempted to change the value of virtual column in a trigger body"

Action: This is not valid, change the trigger definition.

ORA-54030: datatype mismatch between virtual column and expression

Cause: virtual column expression was changed after column was created"

Action: change the underlying expression to return datatype that conforms to the virtual column

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.

Action: Drop the virtual column first or change the virtual column expression to eliminate dependency on the column to be dropped.

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.

Action: Drop the virtual column first or change the virtual column expression to eliminate dependency on the column to be renamed.

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.

Action: Drop the virtual column first or change the virtual column expression to eliminate dependency on the column to be modified.

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.

Action: Specify the index expression using only regular columns.

ORA-54035: keyword HIDDEN cannot be specified here

Cause: Attempted to specify HIDDEN key word for a virtual column

Action: This is not supported.

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.

Action: Reissue the statement without specifying ON DELETE SET NULL clause.

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.

Action: Include at least 1 column that is not virtual in the table being created.

ORA-54038: Virtual column cannot be encrypted

Cause: An attempt was made to create or alter a virtual column to have encryption.

Action: Encryption is unnecessary for a virtual column as the data is not stored on disk.

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.

Action: Include at least one column that is not invisible in the table being created or altered.

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.

Action: This is not supported.

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.

Action: Specify the column visibility change with a supported data type.

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).

Action: These columns are not supported, change the DDL.

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).

Action: This is not supported.

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.

Action: Revoke the column-level object privilege before making the column invisible.

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.

Action: Modify the column to make it visible and then grant the column-level object privilege.

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.

Action: Separate column visibility modifications into a standalone DDL.

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.

Action: Do not create virtual columns for XMLType tables with object-relational storage . This feature is not available.

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.

Action: Separate column expression modifications into a standalone DDL.

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.

Action: These columns are not supported; change the DDL.

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.

Action: Specify the name of a non-redacted column, or use the DROP_POLICY PL/SQL procedure in the DBMS_REDACT package to remove the redaction policy from the column before altering it. Look in the REDACTION_POLICIES and REDACTION_COLUMNS catalog views for a list of all redaction policies and redacted columns.

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.

Action: None

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.

Action: None

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.

Action: Execute the DDL on a table not owned by a 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.

Action: None

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.

Action: Avoid creating 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.

Action: Specify the name of a non-sensitive column, or use the DROP_SENSITIVE_COLUMN PL/SQL procedure in the DBMS_TSDP_MANAGE package to remove the sensitivity of the column before altering it.

ORA-54057: A column which is a audit column of a Fine Grained Auditing policy cannot be modified to an invisible column.

Cause: An attempt was made to modify a column which was a audit column of a FGA policy to an invisbile column.

Action: Drop the FGA policy containing the column as audit column before modifying the column.

ORA-54058: '*' not allowed in SELECT expressions without FROM clause

Cause: An attempt was made to use '*' in select expression list without a FROM clause.

Action: Specify explicit columns or expressions in select list that does not include a '*'