‘Ctrl+F’로 에러 메시지 번호를 검색하시면 문제 발생 원인과 해결 방법을 빠르게 확인하실 수 있습니다.

---

Tibero Error Message 6000~6999

6001: Internal error: DD search failed.
Cause: Failed to search DD (Data Dictionary) due to an internal error.
Action: Contact the technical support team.

6002: Synonym translation is no longer valid.
Cause: The target schema or object does not exist.
Action: Change the definition of the synonym so that the synonym refers to a valid object.

6003: Sequence “%1$s” has not been accessed in this session: no CURRVAL available.
Cause: CURRVAL cannot be used since the indicated sequence has not been used in the current session.
Action: CURRVAL can be used only after NEXTVAL has been used in the same session.

6004: Sequence “%1$s” has exceeded its available range.
Cause: All values available in sequence are already used.
Action: Modify the range of the sequence by using an ALTER SEQUENCE statement.

6005: DB data dictionary version does not match binary DD version.
Cause: The version of the DD in the DB is different from the version of DD in the binary.
Action: The binary cannot be used in the database.

6006: ALTERDD must be run on data dictionary.
Cause: The ALTERDD process must be run to use the DD as the binary.
Action: Execute the ALTERDD process to change DD.

6007: Table “%1$s” cannot be loaded because the size of the constraints on the table is too large.
Cause: The size of the constraints on the table is too large.
Action: Check if the table has unnecessary constraints. Drop unnecessary constraints.

6009: Failed to add a pair in a DD object search key map.
Cause: An internal error occurred during adding a pair in a DD object search key map.
Action: Contact the technical support team.

6010: Failed to add a pair in a DD user search key map.
Cause: An internal error occurred during adding a pair in a DD user search key map.
Action: Contact the technical support team.

6011: Cannot execute the current sequence Nextval with the SCALE_NOEXTEND option.
Cause: The sequence value conflicts with the SCALE prefix value.
Action: Increase the number of digits in the sequence by “%1$u”, or use the SCALE EXTEND option.er of digits in the sequence by “%1$u”, or use the SCALE EXTEND option.

---

Tibero Error Message 7000~7999

7001: General syntax error.
Cause: Syntax error occurred.
Action: Correct the SQL statement.

7002: Unsupported DDL.
Cause: Unsupported DDL (Data Definition Language).
Action: The statement cannot be executed.

7003: The SQL statement is not valid DDL.
Cause: The statement is not valid DDL.
Action: The statement cannot be executed.

7004: This DDL statement is not permitted in the current boot mode.
Cause: In the current boot mode, this DDL cannot be executed.
Action: Change the boot mode and run the DDL statement again.

7005: Missing right parenthesis at line %1$d, column %2$d.
Cause: The right parenthesis is missing.
Action: Check parentheses and try again.

7006: Filename is too long. %1$s.
Cause: The specified filename is too long.
Action: Use a shorter filename and try again.

7007: The specified value is out of range.
Cause: The specified value is either too small or too large.
Action: Specify a valid value and try again.

7008: START WITH is not allowed for ALTER sequences.
Cause: The START WITH option was specified for an ALTER sequence.
Action: The START WITH option is allowed only for CREATE sequences.

7009: Maximum number of columns was exceeded.
Cause: The number of columns exceeds the maximum number allowed.
Action: Specify a number of columns less than the maximum.

7010: Unable to grant privileges other than INSERT, REFERENCE, and UPDATE on column.
Cause: A column privilege was granted to an operation other than INSERT, REFERENCE or UPDATE.
Action: The privilege cannot be granted.

7011: Number of specified files and target files do not match.
Cause: The number of specified files is different from the number of target files.
Action: Ensure that the numbers of files match.

7012: Log group number is invalid.
Cause: The specified log group number is invalid.
Action: Specify a valid log group number.

7013: This option cannot be specified.
Cause: The specified option is invalid.
Action: Specify a valid option.

7014: A filename is required for this DDL statement.
Cause: The filename is not specified.
Action: Specify a valid filename.

7015: Duplicate FORCE LOGGING clause exists.
Cause: A duplicate FORCE LOGGING clause exists.
Action: Delete the duplicate clause.

7016: Duplicate LOGGING clause exists.
Cause: A duplicate LOGGING clause exists.
Action: Delete the duplicate clause.

7017: Duplicate PCTFREE setting exists.
Cause: A duplicate PCTFREE setting exists.
Action: Delete the duplicate setting.

7018: Duplicate INITRANS setting exists.
Cause: A duplicate INITRANS setting exists.
Action: Delete the duplicate setting.

7019: Duplicate STORAGE clause exists.
Cause: A duplicate STORAGE clause exists.
Action: Delete the duplicate clause.

7020: Duplicate MINEXTENTS setting exists.
Cause: A duplicate MINEXTENTS setting exists.
Action: Delete the duplicate setting.

7021: Duplicate MAXEXTENTS setting exists.
Cause: A duplicate MAXEXTENTS setting exists.
Action: Delete the duplicate setting.

7022: Duplicate EXTENT MANAGEMENT clause exists.
Cause: A duplicate EXTENT MANAGEMENT clause exists.
Action: Delete the duplicate clause.

7023: Duplicate ENABLE or DISABLE clause exists on a constraint.
Cause: A duplicate ENABLE or DISABLE clause exists.
Action: Delete the duplicate clause.

7024: Duplicate USING INDEX clause exists.
Cause: A duplicate USING INDEX clause exists.
Action: Delete the duplicate clause.

7025: Duplicate NULL or NOT NULL setting exists.
Cause: A duplicate NULL or NOT NULL setting exists.
Action: Delete the duplicate setting.

7026: Duplicate primary key exists.
Cause: A duplicate primary key exists.
Action: Delete the duplicate.

7027: Duplicate unique key exists.
Cause: A duplicate unique key exists.
Action: Delete the duplicate.

7028: Duplicate ENABLE IN ROW or DISABLE IN ROW setting exists.
Cause: A duplicate ENABLE or DISABLE IN ROW setting exists.
Action: Delete the duplicate setting.

7029: Duplicate CHUNK SIZE setting exists.
Cause: A duplicate CHUNK SIZE setting exists.
Action: Delete the duplicate setting.

7030: Duplicate USER SYS clause exists.
Cause: A duplicate USER SYS clause exists.
Action: Delete the duplicate clause.

7031: Duplicate MAXLOGGROUPS setting exists.
Cause: A duplicate MAXLOGGROUPS setting exists.
Action: Delete the duplicate setting.

7032: Duplicate MAXLOGMEMBERS setting exists.
Cause: A duplicate MAXLOGMEMBERS setting exists.
Action: Delete the duplicate setting.

7033: Duplicate MAXDATAFILES setting exists.
Cause: A duplicate MAXDATAFILES setting exists.
Action: Delete the duplicate setting.

7034: Duplicate NATIONAL CHARACTER SET setting exists.
Cause: A duplicate NATIONAL CHARACTER SET setting exists.
Action: Delete the duplicate setting.

7035: Duplicate ARCHIVELOG or NOARCHIVELOG setting exists.
Cause: A duplicate ARCHIVELOG or NOARCHIVELOG setting exists.
Action: Delete the duplicate setting.

7036: Cannot mix a log group definition that specifies a group number with a definition that does not.
Cause: A definition that specifies a log group number cannot be used with one that does not specify a log group number.
Action: To specify a log group number, ensure log group definitions are not mixed-type.

7037: Duplicate ONLINE or OFFLINE clause exists.
Cause: A duplicate ONLINE or OFFLINE clause exists.
Action: Delete the duplicate clause.

7038: Duplicate TABLESPACE setting exists.
Cause: A duplicate TABLESPACE setting exists.
Action: Delete the duplicate setting.

7039: Unspecified column type.
Cause: A column type was omitted.
Action: Specify a column type.

7040: Unspecified column definition.
Cause: The column definition was omitted.
Action: Specify the definition.

7041: Too many LONG columns are specified.
Cause: Two or more LONG-type columns are specified in one table.
Action: Specify only one LONG-type column.

7042: New column cannot be added to this table.
Cause: The table has a LOB or LONG type column or the number of columns in the table is at the maximum.
Action: Unable to add a new column.

7043: Specified number of columns does not match number of subquery columns.
Cause: The number of specified columns is different from the number of columns in subquery.
Action: Ensure that the numbers of columns match.

7044: Column datatypes cannot be specified with a subquery.
Cause: Cannot specify a column data type with a subquery.
Action: Do not specify a data type.

7045: A column contains a NULL value: cannot create or enable the constraint.
Cause: A column contains a NULL value: NOT NULL or primary key cannot be created.
Action: Check columns for NULL values.

7046: Duplicate INCREMENT BY setting exists.
Cause: A duplicate INCREMENT BY setting exists.
Action: Delete the duplicate setting.

7047: Duplicate START WITH setting exists.
Cause: A duplicate START WITH setting exists.
Action: Delete the duplicate setting.

7048: Duplicate MAXVALUE or NOMAXVALUE setting exists.
Cause: A duplicate MAXVALUE or NOMAXVALUE setting exists.
Action: Delete the duplicate setting.

7049: Duplicate MINVALUE or NOMINVALUE setting exists.
Cause: A duplicate MINVALUE or NOMINVALUE setting exists.
Action: Delete the duplicate setting.

7050: Duplicate CYCLE or NOCYCLE setting exists.
Cause: A duplicate CYCLE or NOCYCLE setting exists.
Action: Delete the duplicate setting.

7051: Duplicate CACHE or NOCACHE setting exists.
Cause: A duplicate CACHE or NOCACHE setting exists.
Action: Delete the duplicate setting.

7052: New password is invalid.
Cause: The new password is invalid.
Action: Specify a valid password.

7053: Password is too long: maximum %1$d characters allowed.
Cause: The password is too long.
Action: Use a shorter password.

7054: Invalid password was entered.
Cause: The previous password was not entered or was invalid.
Action: Recheck the previous password and check that permission to use ALTER USER statement is granted.

7055: Encrypted password is invalid.
Cause: The encrypted password is invalid.
Action: Use a password that is encrypted in a valid style.

7056: Duplicate password exists.
Cause: A duplicate password exists.
Action: Change to a unique password.

7057: Duplicate REPLACE old password statement exists.
Cause: A duplicate REPLACE old password statement exists.
Action: Delete the duplicate statement.

7058: Duplicate DEFAULT TABLESPACE setting exists.
Cause: A duplicate DEFAULT TABLESPACE setting exists.
Action: Delete the duplicate setting.

7059: Duplicate DEFAULT ROLE clause exists.
Cause: A duplicate DEFAULT ROLE clause exists.
Action: Delete the duplicate clause.

7060: Duplicate PASSWORD EXPIRE setting exists.
Cause: A duplicate PASSWORD EXPIRE setting exists.
Action: Delete the duplicate setting.

7061: Duplicate ACCOUNT_LOCK setting exists.
Cause: A duplicate ACCOUNT_LOCK setting exists.
Action: Delete the duplicate setting.

7062: DROP option cannot be used if datafile is online.
Cause: The online datafile cannot be dropped.
Action: Execute the OFFLINE FOR DROP option first.

7063: END BACKUP option cannot be used for a temporary file.
Cause: The END BACKUP option cannot be used for a temporary file.
Action: Unable to execute.

7064: File ‘%1$s’ was not found in this database.
Cause: The file was not found in the current database.
Action: Specify a valid file name.

7065: File number %1$d was not found in this database.
Cause: The file was not found in the current database.
Action: Specify a valid file number.

7066: A log member clause was expected.
Cause: The log member clause was omitted.
Action: Specify the log member clause.

7067: Specified database name ‘%1$s’ does not match parameter database name in tip file ‘%2$s’.
Cause: The specified database name does not match the database name specified in the parameter file.
Action: Match with information in the parameter file. Distinguish but only when using double quotation marks.

7068: Specified schema ‘%1$s’ was not found.
Cause: The specified schema was not found.
Action: Specify a valid schema name.

7069: Specified user ‘%1$s’ was not found.
Cause: The specified user was not found.
Action: Specify a valid user name.

7070: Specified role ‘%1$s’ was not found.
Cause: The specified role was not found.
Action: Specify a valid role.

7071: Schema object ‘%1$s.%2$s’ was not found or is invalid.
Cause: The specified object was not found or is an invalid type.
Action: Specify a valid object name.

7072: Specified column ‘%1$s’ was not found or is invalid.
Cause: The specified column was not found or is an invalid type column.
Action: Specify a valid column name.

7073: Specified tablespace ‘%1$s’ was not found.
Cause: The specified tablespace does not exist.
Action: Specify a valid tablespace name.

7074: Specified tablespace ‘%1$s’ cannot be used as a user’s default tablespace.
Cause: The specified tablespace cannot be used for a default tablespace.
Action: Specify a different tablespace name.

7075: Specified role ‘%1$s’ was not found.
Cause: The specified role does not exist.
Action: Specify a valid role.

7076: Specified constraint ‘%1$s’ was not found.
Cause: The specified constraint does not exist.
Action: Specify a valid constraint name.

7077: Specified target of grant ‘%1$s’ does not exist.
Cause: The specified grantee does not exist.
Action: Specify a valid target name.

7078: Specified target of revoke ‘%1$s’ does not exist.
Cause: The specified revokee does not exist.
Action: Specify a valid target name.

7079: Duplicate column name ‘%1$s’ exists.
Cause: A duplicate column name exists.
Action: Use a unique column name.

7080: Specified column ‘%1$s’.’%2$s’ must be empty before changing datatypes.
Cause: In order to change the column datatype, all columns must be empty.
Action: Clear all columns.

7081: Specified column ‘%1$s’.’%2$s’ must be empty before reducing column length.
Cause: Column lengths cannot be reduced if the column is not empty.
Action: Make the columns null.

7082: Duplicate segment name ‘%1$s’ exists.
Cause: A duplicate segment name exists.
Action: Use a unique segment name.

7083: Duplicate constraint name ‘%1$s’ exists.
Cause: A duplicate constraint name exists.
Action: Use a unique constraint name.

7084: Expression requires a column alias.
Cause: The expression requires a column alias.
Action: Specify a column alias.

7085: Number of column aliases does not match the number of required columns.
Cause: The number of aliases is different from the number of required columns.
Action: Specify a valid number of aliases.

7086: An index cannot be created from columns of type LONG, LONG RAW, LOB, OBJECT, or COLECTION.
Cause: An index cannot be made of certain type columns.
Action: Unable to execute.

7087: ‘%1$s’ is not a table or view so it cannot have columns.
Cause: The object does not have columns.
Action: Check again.

7088: Duplicate grant target name ‘%1$s’ exists.
Cause: A duplicate grantee name exists.
Action: Delete the duplicate grantee name.

7089: Duplicate revoke target name ‘%1$s’ exists.
Cause: A duplicate revokee name exists.
Action: Delete the duplicate revokee name.

7090: Duplicate privilege exists.
Cause: A duplicate privilege exists.
Action: Delete the duplicate privilege.

7091: Duplicate role ‘%1$s’ exists.
Cause: A duplicate role exists.
Action: Delete the duplicate role.

7092: LONG column type cannot be specified in this statement.
Cause: In the CREATE TABLE AS SELECT statement, the LONG type column cannot be specified.
Action: Do not specify a LONG type column.

7093: Synonym cannot have the same name as its target.
Cause: The synonym and its target have the same name.
Action: Try a different synonym.

7094: Unable to decrease column size: a value in the column is too long.
Cause: The data in the existing column is too long.
Action: Specify a column size larger than the length of the data in the existing column.

7095: Unable to create a unique file name.
Cause: Unable to create a new file name.
Action: Change the directory or check to see if the name of the directory is too long.

7096: Unable to create a unique object name.
Cause: Unable to create a new object name.
Action: Avoid any names used internally by DBMS server.

7097: Duplicate filename ‘%1$s’ exists.
Cause: A file with that name already exists.
Action: Specify another file name.

7098: Duplicate tablespace ‘%1$s’ exists.
Cause: A tablespace with that name already exists.
Action: Specify another tablespace name.

7099: Duplicate partition name ‘%1$s’ exists.
Cause: A partition with that name already exists.
Action: Specify another partition name.

7100: Username ‘%1$s’ conflicts with another user or role name.
Cause: A role or user with that name already exists.
Action: Specify another username.

7101: Role name ‘%1$s’ conflicts with another user or role name.
Cause: A role or user with that name already exists.
Action: Specify another role name.

7102: Duplicate schema object ‘%1$s.%2$s’ exists.
Cause: A schema object with that name already exists.
Action: Specify another object name.

7103: Column name ‘%1$s’ is already used in the table.
Cause: A column with that name already exists.
Action: Specify another column name.

7104: Constraint name ‘%1$s’ is already used or is duplicated in the SQL statement.
Cause: The specified constraint name is already being used.
Action: Specify another constraint name.

7105: Unable to rebuild the index of a temporary table.
Cause: An attempt was made to rebuild the index of the temporary table.
Action: It is impossible to rebuild the index of a temporary table.

7106: Size of next extent is out of range.
Cause: The specified size for the new extent is either too small or too large.
Action: Specify a valid size for the new extent.

7107: File size is out of range.
Cause: The specified file size is either too small or too large.
Action: Specify a valid file size.

7108: INITRANS value is out of range.
Cause: The value of INITRANS is either too small or too large.
Action: Specify an integer value between 1 and 255.

7109: PCTFREE value is out of range.
Cause: The value of PCTFREE is either too small or too large.
Action: Specify an integer value between 0 and 99.

7110: MAXDATAFILES value is out of range.
Cause: The value of MAXDATAFILES is either too small or too large.
Action: The number of MAXDATAFILES should be between 10 and 65533.

7111: MAXLOGGROUPS (MAXLOGFILES) must be between 2 and %1$d (inclusive).
Cause: The value of MAXLOGGROUPS is invalid.
Action: Specify a new value for MAXLOGGROUPS.

7112: MAXLOGMEMBERS must be less than %1$d.
Cause: The value of MAXLOGMEMBERS is invalid.
Action: Specify a new value for MAXLOGMEMBERS.

7113: Invalid next extent size or max extent size.
Cause: The next extent or max extent size is invalid.
Action: Specify a valid extent size.

7114: Specified CHARACTER SET is not supported.
Cause: Unsupported character set.
Action: Specify a supported character set.

7115: Log file size is out of range.
Cause: The specified log file size is either too small or too large.
Action: Specify a log file size between 512KB and 1GB.

7116: Invalid data type for default expression.
Cause: The data type of the default expression is invalid.
Action: Specify a valid expression data type.

7117: Unable to create segment in temporary tablespace.
Cause: A segment could not be created in a temporary tablespace.
Action: Specify a valid tablespace.

7118: Unable to create segment in undo tablespace.
Cause: A segment could not be created in an undo tablespace.
Action: Specify a valid tablespace.

7119: Object does not fit into tablespace.
Cause: Permanent objects cannot be created in a temp DB. Temp objects cannot be created in a permanent DB.
Action: Recheck the object.

7120: Unable to define foreign key for temporary table.
Cause: Unable to define foreign key constraint for columns of a global temporary table.
Action: Unable to execute this command.

7121: This clause cannot be specified for the temporary table.
Cause: Tried to specify an invalid clause for the global temporary table.
Action: Unable to execute this command.

7122: Circular view detected.
Cause: The view referred to itself or the view reference object referred to the view.
Action: Delete the circular reference(s) from the view definition.

7123: Too many columns in the index.
Cause: There are more than 32 columns in the index.
Action: Reduce the number of columns in the index to 32 or less.

7124: Duplicate index exists.
Cause: The specified index already exists.
Action: Unable to execute this command.

7125: Maximum key length (%1$u) exceeded.
Cause: The index key length exceeds the maximum length.
Action: Decrease the length of index key by reducing the number of columns in the index.

7126: Unable to alter or drop a LOB index.
Cause: An ALTER or DROP statement cannot be used in an LOB index.
Action: Unable to execute.

7127: Unable to drop the system tablespace.
Cause: System tablespaces cannot be dropped.
Action: Unable to execute this command.

7128: Unable to drop default temporary or undo tablespaces.
Cause: The default temporary or default undo tablespaces cannot be dropped.
Action: Unable to execute this command.

7129: Segments still exist in the specified tablespace.
Cause: Segments still exist in the tablespace to be dropped.
Action: Set the INCLUDING option, or drop the segment and retry.

7130: Unable to drop a user’s default tablespace.
Cause: The tablespace to be dropped is the default tablespace for a user.
Action: Change the user’s default tablespace with ALTER USER and retry.

7131: The user’s default tablespace is invalid.
Cause: A tablespace for the user does not exist.
Action: Specify the default tablespace for ALTER USER.

7132: Unable to drop the (sub)partitions.
Cause: One of the partitions in the table belongs to another tablespace.
Action: Drop the partitioned table and retry.

7133: The sequence INCREMENT must be a non-zero value.
Cause: INCREMENT may not be 0.
Action: Specify a valid INCREMENT value.

7134: The next (start) value of the sequence is out of range.
Cause: The next or start value of the sequence must be between MINVALUE and MAXVALUE.
Action: Specify the MINVALUE and MAXVALUE.

7135: In descending sequences, the CYCLE option must be used with MINVALUE.
Cause: The CYCLE option must be used with MINVALUE.
Action: Specify a MINVALUE.

7136: In ascending sequences, the CYCLE option must be used with MAXVALUE.
Cause: The CYCLE option must be used with MAXVALUE.
Action: Specify a MAXVALUE.

7137: MINVALUE must be less than MAXVALUE.
Cause: MINVALUE must be less than MAXVALUE.
Action: Set MINVALUE to be smaller than MAXVALUE.

7138: Unable to drop the system user.
Cause: The system user cannot be dropped.
Action: Unable to execute this command.

7139: Cascade is required to remove this user from the system.
Cause: If objects owned by the user still exist, the user cannot be removed.
Action: Specify the cascade option, or drop the objects and try again.

7140: Specified object is not partitioned.
Cause: The requested object is not partitioned.
Action: Check whether the specified object is valid.

7141: Specified partition ‘%1$s’ does not exist.
Cause: The requested partition does not exist.
Action: Check whether the specified object is valid.

7142: Last partition cannot be dropped.
Cause: The last partition cannot be dropped.
Action: Unable to execute.

7143: Too many columns in a constraint.
Cause: There are more than 32 columns in the constraint.
Action: Reduce the number of columns in the constraint to 32 or less.

7144: Referenced key does not exist.
Cause: The constraint for that reference does not exist.
Action: Specify a valid constraint.

7145: Primary/unique is not specified for the table.
Cause: The constraint on the key is not specified.
Action: Specify a valid constraint.

7146: Specified column type cannot be a constraint.
Cause: The specified column cannot be used as a constraint.
Action: Specify a valid column.

7147: A table can have only one primary key.
Cause: A table may have only one primary key.
Action: Specify one primary key.

7148: Duplicate unique or primary key exists.
Cause: A unique or primary key with that name already exists.
Action: Delete the duplicate constraint.

7149: Duplicate referential key exists.
Cause: A reference key with that name already exists.
Action: Delete the duplicate constraint.

7150: Duplicate NOT NULL constraint exists.
Cause: A NOT NULL constraint with that name already exists.
Action: Delete the duplicate constraint.

7151: Unable to use existing index as a constraint for a new object.
Cause: The existing index cannot be used as a constraint for a new object.
Action: Specify another index.

7152: Indexes are unnecessary for some constraints.
Cause: An index was specified for a constraint which does not require an index.
Action: Retry without specifying an index.

7153: Index already exists for another object.
Cause: The specified index already exists for another object.
Action: Specify another index.

7154: Column(s) of the specified index do not match that (those) of the new constraint.
Cause: Columns in the specified index do not match with those of the new constraint.
Action: Specify another index.

7155: Only NULL or NOT NULL constraints are available for MODIFY COLUMN statement.
Cause: For the MODIFY COLUMN statement, only NULL or NOT NULL can be specified.
Action: Unable to execute this command.

7156: Referenced by foreign keys.
Cause: Referred by other reference constraint.
Action: Specify the CASCADE CONSTRAINTS clause and retry.

7157: Specified column is already NULL.
Cause: The column is already specified as NULL.
Action: Unable to execute this command.

7158: Unable to set specified column to NULL.
Cause: The specified column cannot be NULL.
Action: Make sure that the column is not specified as containing primary keys.

7159: Number of local index partitions does not match the number of table partitions.
Cause: The specified number of local index partitions is different from the number of partitions in the table.
Action: Specify the valid number of partitions.

7160: Unable to create local partitioned index for non-partitioned table.
Cause: Unable to create a local partition index for a non-partitioned table.
Action: Unable to execute this command.

7161: Unable to validate (%1$s.%2$s): constraint violated.
Cause: The table has a row which violates one or more constraints.
Action: Modify the row or change the constraint state.

7162: Unable to activate (%1$s.%2$s): referenced key is not enabled.
Cause: The referenced key is disabled: therefore, the foreign key is not available.
Action: Enable the referenced key first.

7163: Specified partition values are incorrect.
Cause: The specified partition value is invalid.
Action: Specify a valid partition value.

7164: Indexes that are used as primary/unique key constraints cannot be dropped.
Cause: Indexes used as primary/unique key constraints cannot be dropped.
Action: Unable to execute this command.

7165: Unable to drop a user that is currently connected.
Cause: A connected user cannot be dropped.
Action: Disconnect the user and try again.

7166: Unable to grant privileges or roles to oneself.
Cause: Privileges and roles cannot be granted to oneself.
Action: Unable to execute this command.

7167: Roles cannot be granted to themselves.
Cause: Roles cannot be granted to themselves.
Action: Unable to execute this command.

7168: Unable to revoke privileges or roles from oneself.
Cause: Unable to revoke one’s own privileges or roles.
Action: Unable to execute this command.

7169: Role has not been granted to the user.
Cause: Unable to revoke a role that has not been granted.
Action: Specify a role that has been granted and try again.

7170: Object privilege has not been granted to the user.
Cause: Unable to revoke an object privilege that has not been granted.
Action: Specify a privilege that has been granted and try again.

7171: System privilege has not been granted to user.
Cause: Unable to revoke a system privilege that has not been granted.
Action: Specify the granted system privilege and try again.

7172: Unable to revoke a privilege granted by another user.
Cause: Unable to revoke a privilege granted by another user.
Action: First receive the privilege to revoke and then revoke the user’s privilege.

7173: Circular role grant detected.
Cause: Roles cannot be granted circularly.
Action: Delete the circular GRANT option.

7174: Unable to grant privileges to a role with GRANT option
Cause: Roles cannot be specified when using the GRANT option.
Action: Unable to execute this command.

7175: There is no privilege to grant.
Cause: No privilege to grant.
Action: Specify a privilege to grant.

7176: The ADMIN option can only be specified for system privileges or roles.
Cause: The ADMIN option can be specified only for system privileges or roles.
Action: Use the GRANT option instead of the ADMIN option.

7177: The ADMIN option can only be specified for system privileges.
Cause: The ADMIN option can be specified only for system privileges.
Action: Use the GRANT option instead of the ADMIN option.

7178: Specified object privilege is invalid for this object.
Cause: The specified schema object privilege cannot be granted to the object.
Action: Check that a valid privilege or object is specified.

7179: Unable to activate a role ‘%1$s’ that has not been granted.
Cause: A role that has not been granted cannot be enabled.
Action: Specify a role that has been granted to you.

7180: Password specified for the role is incorrect.
Cause: Invalid password specified for the role.
Action: Specify a valid password.

7181: Password is necessary to enable the role.
Cause: The password is needed to enable roles.
Action: Enter the password.

7182: Package specification for the body was not found.
Cause: A package specification for the body was not found.
Action: Check whether or not the package specification exists.

7183: Package body is already defined.
Cause: The body is already defined for the package.
Action: Specify or replace and redefine.

7184: Circular dependency detected.
Cause: The object about to be created or updated is dependent on itself.
Action: Examine the dependencies and modify the source code.

7185: Unable to drop specified undo tablespace.
Cause: The specified undo tablespace cannot be dropped because it does not exist in CORRUPTEDCORRUPTED UNDO_TS.
Action: Specify undo tablespace as _CORRUPTED_UNDO_TS parameter in init file.

7186: Unable to modify objects created by the system.
Cause: Objects made by the system cannot be modified.
Action: Unable to execute this command.

7187: Duplicate parameter name exists.
Cause: Parameter name is duplicated.
Action: Delete the duplicate name.

7188: Unable to rename objects inside other schema.
Cause: The name of an object belonging to another schema cannot be changed.
Action: Unable to execute this command.

7189: Unable to replace ‘%1$s.%2$s’: object is of a different type.
Cause: Unable to replace an object with another of a different type.
Action: Unable to execute this command.

7190: Unable to ALTER/DROP ‘%1$s.%2$s’: object is of a different type.
Cause: Unable to ALTER or DROP an object of a different type.
Action: Unable to execute this command.

7191: Unable to execute SET TRANSACTION: transaction has already started.
Cause: Transaction is already started. SET TRANSACTION cannot be executed.
Action: Unable to execute this command.

7192: Failed to load DDL file ‘%1$s’.
Cause: Failed to load a DDL file.
Action: Make sure that the file exists.

7193: Invalid local transaction ID.
Cause: Invalid local transaction ID.
Action: Check that the specified local transaction ID is valid.

7194: Unable to (re-)create system datafile (file #0).
Cause: The first file of a system tablespace cannot be regenerated.
Action: Unable to execute this command.

7195: Update check constraint has “OR” node.
Cause: For example “update A or B” is invalid.
Action: Unable to execute this command.

7196: Invalid directory path. Please enter the absolute path.
Cause: Invalid directory path.
Action: Enter an absolute path.

7197: Invalid initialization parameter name ‘%1$s’.
Cause: Invalid initialization parameter name.
Action: Recheck the parameter name.

7198: Unable to modify parameter ‘%1$s’ dynamically.
Cause: This initialization parameter cannot be modified dynamically.
Action: Restart the server or regenerate the database.

7199: Type mismatch for parameter ‘%1$s’: %2$s required.
Cause: The type of initialization parameter required is different from the one defined in DDL.
Action: Recheck the parameter type.

7200: Value of parameter ‘%1$s’ is invalid (condition check failed: ‘%2$s’).
Cause: This initialization parameter is out of range.
Action: Check the parameter range again.

7201: Parameter ‘%1$s’ cannot be modified by ALTER SESSION.
Cause: This initialization parameter cannot be adjusted by sessions.
Action: Use ALTER SYSTEM statements, instead of ALTER SESSION.

7202: Too many partition key columns are specified.
Cause: The number of columns used in a constraint exceeds 32.
Action: Specify a number of columns less than 32.

7203: File ‘%1$s’ does not exist or is not accessible.
Cause: File does not exist or is not accessible.
Action: Check file name and permissions.

7204: Requested session does not exist. Session id: %1$d
Cause: The session does not exist.
Action: Check the session id.

7205: %1$s.
Cause: Performs dump.
Action: Normal action.

7206: Specified column is already NOT NULL.
Cause: The specified column is already specified as NOT NULL.
Action: Unable to execute this command.

7207: New identifier required: ‘%1$s’ is a reserved word.
Cause: Reserved words cannot be used as identifiers.
Action: Use another name.

7208: Partition value is too long.
Cause: The length of partition bound value is longer than that of the corresponding partitioning key column.
Action: Ensure that lengths of partition bound values do not exceed those of corresponding partitioning columns.

7209: Duplicate clause exists (type %1$s, previously at line %2$d, column %3$d).
Cause: Duplicate clause was found.
Action: Use only one instance of a clause.

7210: Internal SQL execution failed (%1$s).
Cause: Failed to execute an SQL statement used internally in DDL.
Action: Contact the technical support team.

7212: Unable to create permanent object in a temporary tablespace or temporary object in a permanent tablespace.
Cause: The object about to be created does not match the tablespace type.
Action: Recheck the statement.

7213: Number of log groups or log files exceeds MAXLOGGROUPS or MAXLOGFILES.
Cause: The number of defined log groups or log files is larger than MAXLOGGROUPS or MAXLOGFILES.
Action: Decrease the number of log group or file definitions, or increase the value of MAXLOGGROUPS or MAXLOGFILES.

7214: Number of log members exceeds MAXLOGMEMBERS.
Cause: The number of defined log members is larger than MAXLOGMEMBERS.
Action: Decrease the number of log members or increase the value of MAXLOGMEMBERS.

7215: Too many partitions are specified.
Cause: The number of defined partitions exceeds 10,000.
Action: Reduce the number of partitions to less than 10,000.

7216: MAXSIZE is less than the specified (default) file size.
Cause: The value of MAXSIZE is smaller than the size of the file.
Action: Increase the value of MAXSIZE and the file size.

7217: Unable to disable constraint (%1$s.%2$s). Dependencies exist.
Cause: There are constraints that reference the specified constraint.
Action: Disable or drop the constraints that reference the specified constraint.

7218: Unable to drop active undo tablespace.
Cause: In the undo tablespace, active transactions exist or undo retention has not yet finished.
Action: Retry after active transactions and undo retention are finished.

7219: RemoteDB name is too long (maximum of %1$d characters).
Cause: RemoteDB name is too long.
Action: Use a shorter RemoteDB name.

7220: Host name is too long (maximum of %1$d characters).
Cause: Host name is too long.
Action: Use a shorter host name.

7221: Duplicate RemoteDB name ‘%1$s’ exists.
Cause: The specified RemoteDB name is already being used.
Action: Specify a different RemoteDB name.

7222: Specified RemoteDB ‘%1$s’ does not exist or is an invalid type.
Cause: The specified RemoteDB does not exist or is an invalid type.
Action: Provide a valid RemoteDB name.

7223: DDL operations are not allowed on a remote database.
Cause: DDL cannot be executed in the remote database.
Action: Unable to execute this command.

7224: Specified table ‘%1$s’ is of a different partition type.
Cause: The partition type of the given table does not match the input statement type.
Action: Correct the partition type and retry.

7225: Global partition index must be prefixed by the partition key column.
Cause: Partition key column of global partition index should come first before index key column.
Action: Adjust the order of index key columns or partition key columns.

7226: Specified subpartition name ‘%1$s_%2$s’ is too long (maximum of %3$d characters).
Cause: The specified subpartition name is too long.
Action: Use a shorter partition or subpartition name.

7227: Default partition must be the last partition specified.
Cause: A partition other than the last one (or no partition) was set as the default.
Action: Set the last partition as the default.

7228: DEFAULT cannot be specified with other values.
Cause: DEFAULT cannot be used with the values of other partitions.
Action: Delete the values of other partitions from the default partition.

7229: Duplicate partition ‘%1$s’ exists.
Cause: The partition value is duplicated.
Action: Delete the duplicate partition value.

7230: List partitioning allows only a single partitioning key column.
Cause: For list partitioning, only one partitioning column can be specified.
Action: Specify one partitioning column.

7231: Unable to use this clause for an external table.
Cause: Invalid clause is specified for an external table.
Action: Unable to execute this command.

7232: Duplicate option was specified.
Cause: Duplicate option was specified.
Action: Delete the duplicate option and retry.

7233: Unable to drop columns of a SYS-owned table.
Cause: Tables owned by SYS cannot execute DROP COLUMN.
Action: Unable to execute this command.

7234: Unable to drop partitioning key column ‘%1$s’.
Cause: An attempt was made to delete a column that is used as a partitioning key.
Action: Unable to execute this command.

7235: Unable to drop all columns within a table.
Cause: An attempt was made to delete all columns in the table.
Action: Unable to execute this command.

7236: Reference key column ‘%1$s’ cannot be dropped.
Cause: An attempt was made to drop the reference key column.
Action: Remove the constraint first, or use CASCADE CONSTRAINTS.

7237: Specified column ‘%1$s’ cannot be modified.
Cause: The column cannot be modified.
Action: LOB, LONG, or partitioning key columns cannot be modified. Delete them or add new columns.

7238: Specified column ‘%1$s’.’%2$s’ must be empty to decrease precision or scale.
Cause: To decrease column’s precision or scale, columns of the all existing rows should be NULL.
Action: Set column to NULL.

7239: Referencing or referenced key column ‘%1$s’ cannot be modified.
Cause: An attempt was made to modify a referencing or referenced key column.
Action: Remove the constraint first and try again.

7240: Tables with LONG-type columns cannot be partitioned.
Cause: An attempt was made to partition tables with LONG-type columns.
Action: Unable to execute this command.

7241: Partitioning column cannot be of type BLOB, CLOB, or ROWID.
Cause: An attempt was made to use BLOB, CLOB or ROWID-type columns as partitioning columns.
Action: Unable to execute this command.

7242: New partitions cannot be added if a DEFAULT partition exists.
Cause: A new partition cannot be added because one of the partition values is DEFAULT.
Action: Unable to execute this command.

7243: Unable to resolve data type of column ‘%1$s’.
Cause: Invalid data type is included in the column.
Action: Unable to execute this command.

7244: Operation not supported on external tables.
Cause: The statement is not supported on external tables.
Action: Unable to execute this command.

7245: Duplicate username ‘%1$s’ exists.
Cause: Duplicate username exists.
Action: Delete the duplicate user.

7246: BY ACCESS/SESSION clause not allowed for NOAUDIT clauses.
Cause: BY ACCESS/SESSION clauses cannot be used for NOAUDIT clauses.
Action: Delete the BY ACCESS/SESSION clause.

7247: Unable to drop the LOB column.
Cause: An LOB-type column also exists in a table that belongs to another tablespace.
Action: Delete the LOB-type column or table first and then retry.

7248: Unable to drop the LOB (sub)partitions.
Cause: An LOB partition also exists in a table that belongs to another tablespace.
Action: Delete the LOB-type column or table first and then retry.

7249: Index ‘%1$s’ is being built or rebuilt.
Cause: The index is being built or rebuilt.
Action: Wait until the online build is completed.

7250: Table is not partitioned by RANGE or LIST method.
Cause: An attempt was made to remove a partition of a table partitioned in a way other than RANGE or LIST partitioning.
Action: Unable to execute this command.

7251: Unable to perform this task on a disabled index.
Cause: An attempt was made to perform this task on a disabled index.
Action: Unable to execute this command.

7252: Unable to execute a savepoint while performing a PDML transaction.
Cause: An attempt was made to execute a savepoint while performing a PDML transaction.
Action: Perform the PDML transaction after committing or rolling back.

7253: Table is not partitioned by RANGE, HASH, or LIST methods.
Cause: A table which is not partitioned by RANGE, HASH or LIST methods cannot be moved.
Action: Unable to execute this command.

7254: ON COMMIT attribute is incompatible with START WITH or NEXT options.
Cause: An ON COMMIT statement is not compatible with START WITH or NEXT options.
Action: Delete the ON COMMIT statement, or remove the START WITH or NEXT option.

7255: START WITH or NEXT should be followed by a date value.
Cause: A date value should come after a START WITH or NEXT option.
Action: Specify a date value after START WITH or NEXT option.

7256: Unable to use AUDIT or NODAUDIT on SYS user operations.
Cause: An attempt was made to execute AUDIT or NODAUDIT on user SYS.
Action: Unable to execute this command.

7257: Invalid encryption algorithm.
Cause: Invalid encryption algorithm name.
Action: Specify a value encryption algorithm name.

7258: Encryption specification does not match.
Cause: Invalid encryption algorithm or password.
Action: Check the encryption algorithm or password again.

7259: Unable to encrypt columns of that type.
Cause: Unable to encrypt data columns of that type.
Action: Unable to execute this command.

7260: Specified object is not encrypted.
Cause: The requested object is not encrypted.
Action: Verify that this is correct.

7261: Unable to drop container table of materialized view.
Cause: The table is used as a container table of materialized view.
Action: Remove the materialized view first.

7262: PCTTHRESHOLD is out of range.
Cause: The specified PCTTHRESHOLD is either too large or too small.
Action: Specify a valid PCTTHRESHOLD value.

7263: Primary key constraint was not found.
Cause: A primary key is necessary.
Action: Specify a primary key.

7264: Composite partitioning is not supported for index-organized tables.
Cause: Composite partitioning is not supported.
Action: Use another partitioning method.

7265: Unable to drop or disable the primary key constraint for index-organized tables.
Cause: A primary key for an index-organized table must exist at all times.
Action: Unable to execute this command.

7266: WHEN clauses may not be used in INSTEAD OF triggers.
Cause: A WHEN clause cannot be used in INSTEAD OF triggers.
Action: Delete the WHEN clause when creating an INSTEAD OF trigger.

7267: INSTEAD OF triggers may not be created on tables.
Cause: Cannot create INSTEAD OF triggers on tables.
Action: Unable to execute this command.

7268: INSTEAD OF triggers may not be created on a read-only view.
Cause: Cannot create INSTEAD OF triggers on a read-only view.
Action: Unable to execute this command.

7269: Column lists are not valid for this trigger type.
Cause: Cannot specify a column list for the trigger.
Action: Delete the column list.

7270: Table or view ‘%1$s.%2$s’ was not found.
Cause: A table or view with the specified name could not be found.
Action: Verify the table or view name.

7271: A view is not allowed for this clause.
Cause: A view cannot be used for the specified clause.
Action: Unable to execute.

7272: This clause may not be used for a HASH partition.
Cause: The clause cannot be used for a hash partition.
Action: Delete the clause.

7273: Unable to convert specified value ‘%1$s’ of the column.
Cause: The specified value does not match the column type.
Action: Specify a value that matches the column.

7274: Specified value ‘%1$s’ is too large for the column.
Cause: The specified value is too long.
Action: Specify a value that matches the length of the column.

7275: This clause is only available for TAC.
Cause: The clause is only available for TAC, and cannot be used for a single instance.
Action: Remove the clause.

7276: Subpartition descriptions cannot be specified.
Cause: Cannot specify subpartition definitions.
Action: Delete the description.

7277: This command cannot be used for a composite partitioned index.
Cause: Cannot be executed for a composite partitioned index.
Action: Unable to execute this command.

7278: Numbers of columns do not match.
Cause: The numbers of columns in the tables do not match.
Action: Unable to execute this command.

7279: Column datatypes do not match.
Cause: The types of columns in the tables do not match.
Action: Unable to execute this command.

7280: Index key columns do not match.
Cause: Index key columns in the tables do not match.
Action: Unable to execute this command.

7281: Allowed only for a local partitioned index.
Cause: Can be executed only for a local partitioned index.
Action: Unable to execute this command.

7282: Index types do not match.
Cause: Index types and attributes do not match.
Action: Unable to execute this command.

7283: Success with compilation errors.
Cause: The object is not available due to compiler error(s) that occurred during its creation.
Action: Check and correct the compiler error(s).

7284: Specified object ‘%1$s.%2$s’ was not dropped.
Cause: The specified object was not removed.
Action: Unable to execute this command.

7285: Not allowed in clustered database mode.
Cause: Not supported in TAC mode.
Action: Retry this command in single instance mode.

7286: Encrypted column ‘%1$s’ is not allowed.
Cause: Unable to use an encrypted column.
Action: Unable to execute this command.

7287: Some rows in the table are invalid for the specified partition.
Cause: Some rows cannot be inserted in the specified partition.
Action: Remove the invalid rows and try again.

7288: Unable to encrypt index key column(s) with SALT.
Cause: An attempt was made to encrypt index key columns with the SALT option.
Action: The SALT option cannot be used to encrypt index key columns.

7289: R-tree index allows only one index key column.
Cause: An attempt was made to specify two or more key columns for an R-tree index.
Action: Specify only one key column for an R-tree index.

7290: R-tree index cannot be partitioned.
Cause: An attempt was made to partition an R-tree index.
Action: An R-tree index cannot be partitioned.

7291: R-tree index can be created only on a column of GEOMETRY type.
Cause: The R-tree index key column is not of GEOMETRY type.
Action: An R-tree index key column must be of GEOMETRY type.

7292: Table ‘%1$s’ does not contain a primary key constraint.
Cause: The WITH PRIMARY KEY was specified but the table did not contain a primary key constraint or the constraint was disabled.
Action: Specify the WITH ROWID option only and try again. Create a primary key constraint in the table.

7293: Invalid filter column detected.
Cause: No filter column exists, or the filter column is a primary key.
Action: Check if all filter columns exist, and ensure that the primary key column is not in a filter column.

7294: There is no materialized view log on table ‘%1$s’.’%2$s’.
Cause: There is no materialized view log on the table.
Action: Check the table name or create a materialized view log on the table.

7295: Table ‘%1$s’ does not contain a primary key constraint.
Cause: The table does not have a primary key constraint.
Action: Create a primary key constraint and try again.

7296: Materialized view does not include all primary key columns.
Cause: A primary key column does not exist in the SELECT statement.
Action: Specify a primary key column in the SELECT or FAST statement.

7297: Prebuilt table “%1$s”.”%2$s” does not exist.
Cause: The specified prebuilt table does not exist.
Action: Try again with the BUILD IMMEDIATE and BUILD DEFERRED options.

7298: Materialized view cannot use a prebuilt table.
Cause: An attempt was made to use a prebuilt table.
Action: Try again with the BUILD IMMEDIATE and BUILD DEFFERED options.

7299: Table “%1$s”.”%2$s” is currently being redefined.
Cause: The table is currently being online redefined.
Action: Wait until the online redefinition is finished.

7300: Table “%1$s”.”%2$s” is currently not being redefined.
Cause: The table is not being online redefined.
Action: Unable to execute this command.

7301: Column “%1$s” is not encrypted.
Cause: The column is not encrypted.
Action: Unable to execute this command.

7302: Column “%1$s” is already encrypted.
Cause: The column is already encrypted.
Action: Unable to execute this command.

7303: Referenced or referencing foreign key constraint column cannot be encrypted.
Cause: An attempt was made to encrypt a referenced or referencing column in a foreign key constraint.
Action: Referenced or referencing columns in foreign key constraints cannot be encrypted.

7304: DOMAIN index allows only one index key column.
Cause: An attempt was made to specify more than one DOMAIN index key column.
Action: Specify only one DOMAIN index key column.

7305: DOMAIN index cannot be partitioned.
Cause: An attempt was made to partition a DOMAIN index.
Action: Unable to partition the DOMAIN index.

7306: XML index can be created only on a column of XMLTYPE type.
Cause: XML index key column is not of XMLTYPE type.
Action: XML index key column must be of XMLTYPE type.

7307: XML index cannot be created in a partitioned table.
Cause: An attempt was made to create an XML index in a partitioned table.
Action: Unable to create an XML index in a partitioned table.

7308: Function-based index cannot be created in an encrypted column (“%1$s”).
Cause: An attempt was made to create a function-based index in an encrypted column.
Action: Unable to create a function-based index in an encrypted column.

7309: Prebuilt table dimensions do not match the definition query.
Cause: The query that defined a materialized view does not match the prebuilt table.
Action: Ensure the prebuilt table matches the query or modify the query using BUILD IMMEDIATE and BUILD DEFERRED and try again.

7310: A non-cacheable expression is not valid for query rewrite.
Cause: An attempt was made to use a non-cacheable expression for the query rewrite function.
Action: Unable to use a non-cacheable expression for the query rewrite function.

7311: Operation is unnecessary.
Cause: The command does not need to be executed.
Action: Do not execute the command.

7312: Original name being used.
Cause: The original name is currently being used by another object.
Action: Use RENAME clause.

7313: Specified undo tablespace name ‘%1$s’ does not match parameter undo tablespace name in tip file ‘%2$s’.
Cause: The specified undo tablespace name ‘%1$s’ does not match parameter undo tablespace name in tip file ‘%2$s’.
Action: Match the two names.

7314: Partitioning columns must be contained in index key columns.
Cause: Partitioning columns must be contained in index key columns.
Action: Use non-unique index or ensure the index key columns include partitioning columns.

7315: Table “%1$s”.”%2$s” does not have a materialized view log.
Cause: Fast refresh is unavailable because the master table does not have a materialized view log.
Action: Create a master table materialized view log.

7316: Materialized view log for “%1$s”.”%2$s” does not record the primary key.
Cause: Fast refresh is unavailable because the materialized view log does not have a primary key.
Action: Create a materialized view log with a primary key.

7317: Unable to use rowid column from materialized view log on “%1$s”.”%2$s”
Cause: The materialized view log does not have a rowid column.
Action: Create a materialized view log with rowid.

7318: Unable to create a fast refresh materialized view from a complex query.
Cause: ROWIDs and primary key constraints are not supported for complex queries.
Action: Use the ‘REFRESH FORCE’ or the ‘REFRESH COMPLETE’ option and try again.

7319: Materialized view log on “%1$s”.”%2$s” does not have new values.
Cause: The materialized view log has no new values information.
Action: Create a materialized view log containing new values.

7320: Unable to use filter columns of the materialized view log on “%1$s”.”%2$s”
Cause: The materialized view log is not recording necessary filter columns.
Action: Add filter columns to the materialized view log.

7321: Schema object ‘%1$s.%2$s.%3$s’ does not exist or is of incompatible type.
Cause: The specified object does not exist or is of incompatible type.
Action: Specify the name of valid object.

7322: Materialized view log already exist on table ‘%1$s’.
Cause: A materialized view log already exists on the table.
Action: Use ‘alter materialized view log’.

7323: Materialized view log on “%1$s”.”%2$s” already has primary keys.
Cause: The materialized view log already has primary keys.
Action: The materialized view log does not need more primary keys.

7324: Materialized view log on “%1$s”.”%2$s” already has a rowid.
Cause: The materialized view log already has a rowid.
Action: The materialized view log does not need another rowid.

7325: Materialized view log on “%1$s”.”%2$s” already has a sequence.
Cause: The materialized view log already has a sequence.
Action: The materialized view log does not need another sequence.

7326: Materialized view log on “%1$s”.”%2$s” already has new values.
Cause: The materialized view log already has new values.
Action: The materialized view log does not need more new values.

7327: Materialized view “%1$s”.”%2$s” is INVALID and needs a complete refresh.
Cause: The materialized view is currently invalid.
Action: Perform a complete refresh of the materialized view.

7328: Materialized view ‘%1$s’.’%2$s’ does not exist.
Cause: The materialized view does not exist.
Action: Check the materialized view.

7329: Unable to explicitly refresh a NEVER REFRESH materialized view (“%1$s”)
Cause: An attempt was made to explicitly refresh a NEVER REFRESH materialized view (“%1$s”)
Action: The materialized view cannot be refreshed.

7330: Materialized view log on “%1$s”.”%2$s” younger than last refresh
Cause: The materialized view log is younger than the last refresh.
Action: Perform a complete refresh.

7331: CTXCAT index allows only char/varchar type key columns.
Cause: An attempt was made to specify an invalid type key column.
Action: Specify only char/varchar type key columns.

7332: Specified parameter value is invalid.
Cause: An attempt was made to specify an invalid parameter value.
Action: Check the parameter value.

7333: Unable to alter or drop a domain indexed column.
Cause: An ALTER or DROP statement cannot be used in the domain indexed column.
Action: Unable to execute.

7334: Domain index is invalid.
Cause: Domain index is invalid.
Action: Unable to execute.

7335: Partitioning columns must form a subset of key columns of a UNIQUE index.
Cause: Partition key column of local partition index should be a subset of index key column.
Action: Unable to execute.

7336: Cannot perform a fast refresh of the materialized view “%1$s”.”%2$s”
Cause: ROWIDs of certain tables were missing in the definition.
Action: Specify the FORCE or COMPLETE option.

7337: Fast refresh of “%1$s”.”%2$s” is unsupported after deletion/update.
Cause: This materialized view does not support the fast refresh after deletion or updates.
Action: Use the complete refresh.

7338: Cannot set the ON COMMIT refresh attribute for the materialized view.
Cause: Conditions for refresh at commit time were not satisfied.
Action: Specify valid options.

7339: Cannot replace the trigger. The trigger is already on other table ‘%1$s.%2$s’.
Cause: Cannot replace a trigger that exists on a different table than the one currently being replaced.
Action: Drop and create a trigger instead of replacing it.

7340: Sequence cache size must be less than one cycle.
Cause: Sequence cache size is larger than one cycle.
Action: Increase the cycle, or decrease the cache size.

7341: Unable to resolve the index key column expression ‘%1$s’.
Cause: An expression that cannot be resolved is included in the index key column.
Action: Unable to execute the command.

7342: Unable to resolve the check condition ‘%1$s’.
Cause: An expression that cannot be resolved is included in the check condition.
Action: Unable to execute the command.

7343: Up to %1$d error codes can be specified to dump the callstack.
Cause: Too many error codes are specified.
Action: Decrease the number of error codes.

7344: Too many primary key columns specified in the Index-Organized Table.
Cause: The number of primary keys specified in the Index-Organized Table is between 1 and 32.
Action: Specify 32 or less primary keys in Index-Organized Table.

7345: The PCTTHRESHOLD value (%1$d) is incorrectly specified.
Cause: The specified PCTTHRESHOLD is incorrect.
Action: Specify PCTTHRESHOLD between 1 and 50.

7346: Index-Organized Table cannot include a LONG type column.
Cause: Index-Organized Table cannot include a LONG type column.
Action: Delete the LONG type column.

7347: The INCLUDING column (%1$s) is incorrectly specified.
Cause: The INCLUDING column must be specified as the last column of a primary key or a non-primary key column.
Action: Specify the INCLUDING column according to the conditions.

7348: An OVERFLOW segment is not specified.
Cause: An OVERFLOW segment must be specified when INCLUDING is specified or the number of column exceeds 255.
Action: Specify an OVERFLOW segment.

7349: The primary key column is not located before other columns.
Cause: When creating an IOT, the primary key column must be described before other columns.
Action: Describe the primary key column before other columns in the IOT create DDL statement.

7350: This DDL statement is not permitted in the massive cluster system.
Cause: In the massive cluster system, this DDL cannot be executed.
Action: Unable to execute.

7351: DDL to be executed in a slave node failed.
Cause: A slave node is not operating.
Action: Unknown cause of error.

7352: The specified event conditional clause (‘%1$s’) is incorrect.
Cause: The specified event conditional clause is incorrect.
Action: Check the conditional clause of the event to be handled.

7353: The profile ‘%1$s’ was not found or is invalid.
Cause: The specified profile was not found or is an invalid type.
Action: Specify a valid profile name.

7354: Cannot drop the profile ‘%1$s’.
Cause: There is a user who uses the profile.
Action: Try again using the CASCADE option.

7355: Cannot drop the specified temporary tablespace.
Cause: The specified temporary tablespace cannot be dropped because it is in use.
Action: Wait until the temporary tablespace is inactive.

7356: Unable to rename the system tablespace.
Cause: System tablespaces cannot be renamed.
Action: Unable to execute this command.

7357: The initialization parameter value, ‘%1$s’, is not an absolute path.
Cause: The value of the initialization parameter is not an absolute path.
Action: Ensure the value of the initialization parameter is an absolute path.

7358: A log group that does not exist cannot be dropped.
Cause: The specified log group does not exist.
Action: Check the log group.

7359: The supplemental logging, ‘%1$s’, does not exist thus cannot be deleted.
Cause: The supplemental logging attribute does not exist.
Action: Check the supplemental logging attribute.

7360: The supplemental logging attribute, ‘%1$s’, already exists.
Cause: The supplemental logging attribute already exists.
Action: Check the supplemental logging attribute.

7361: Integer value required.
Cause: The input value must be an integer.
Action: Use an integer value expression as the input.

7362: This DDL statement is not allowed on a bitmap indexed table.
Cause: The table must not have any bitmap indexes.
Action: Ensure bitmap indexes do not exist on this table.

7363: The resource limit, ‘%1$s’, is invalid.
Cause: The appropriate resource limit should be provided.
Action: Ensure the resource limit is valid.

7364: Partitioning is not supported for index-organized tables.
Cause: Partitioned IOT is not supported.
Action: Unable to execute this command.

7365: The unique index needs hash data sharding in the massive cluster system.
Cause: In the massive cluster system, this DDL cannot be executed.
Action: Unable to execute. The table needs a hash data sharding property.

7366: It is impossible to delete or modify the type due to a dependency.
Cause: The type has a dependency on another type or table.
Action: Delete the types or tables between which a dependency is set, or use the force option to drop the type or table which has a dependency.

7367: BUCKET option is not permitted on non-hash data sharding.
Cause: BUCKET option is not permitted on non-hash data sharding.
Action: Unable to execute. The table needs a hash data sharding property.

7368: Specified bucket not found: %1$d.
Cause: Specified bucket number is not correct.
Action: Check bucket number by _DD_TABLET_MEMBER.

7369: Cannot delete the last bucket of hash data sharding.
Cause: Specified bucket is the last bucket tablet.
Action: Add a new bucket and create a new last bucket tablet. Delete the 2nd to last bucket.

7370: Cannot create the diskspace.
Cause: Creating the diskspace failed due to an unknown reason.
Action: Check the logs.

7371: The diskspace name already exists.
Cause: A diskspace with the same name already exists.
Action: Check the diskspace name.

7372: The disk is already in use.
Cause: Another diskspace is already using the disk.
Action: Check the path to the disk.

7373: The disk has been assigned already.
Cause: The disk has been assigned already.
Action: Check the path to the disk.

7374: Cannot create a new diskspace.
Cause: The number of diskspace is full.
Action: Check the number of available diskspace.

7375: DISK OPEN failed.
Cause: Failed to open the disk.
Action: Check the logs.

7376: DISK READ failed.
Cause: Failed to read from the disk.
Action: Check the logs.

7377: DISK WRITE failed.
Cause: Failed to write to the disk.
Action: Check the logs.

7378: The device type is invalid.
Cause: Only file, raw device, or symbolic link can be used as device type.
Action: Check the device type.

7379: The disk size is invalid.
Cause: The specified disk size is too big or invalid.
Action: Check the disk size.

7380: The file size is invalid.
Cause: The specified file size is too large or invalid.
Action: Compare the file size to the number and size of disks.

7381: The sector size is invalid.
Cause: The specified sector size does not match the device sector size.
Action: Check the device sector size.

7382: Cannot find the path to the disk.
Cause: The DISK_PATH is not set in the configuration file or the DISK_PATH value is invalid.
Action: Check the DISK_PATH setting in the configuration file.

7383: The shared memory space in the system is insufficient.
Cause: The diskspace information cannot be created due to a lack of shared memory space in the system.
Action: Increase the shared memory space in the system.

7384: The specified number of disks exceeds the maximum number allowed.
Cause: The maximum number of disks allowed for a diskspace is 65535.
Action: Check the number of disks required for the DDL statement.

7385: Specified group not found: %1$s.
Cause: Specified group name is not correct.
Action: Check group name by horde configuration.

7386: Table is not a global table.
Cause: Table is a local table which is created when TMC_LOCAL_SESS=N.
Action: Use another name or drop the table in local session.

7387: Table is not a local table.
Cause: Table is a global table which is created when TMC_LOCAL_SESS=Y.
Action: Use another name or drop the table in global session.

7388: Specified group not match the original group.
Cause: Cannot move to another group.
Action: Check group name or use FORCE keyword.

7389: Specified group has no node member.
Cause: Specified group name is not correct or group is empty.
Action: Check group name or group configuration.

7390: Specified tablet number not found.
Cause: Specified tablet number is not correct.
Action: Check tablet number by _dd_tablet_member.

7391: Index-organized tables are not supported in TMC.
Cause: Index-organized tables are not supported.
Action: Use supported sharding methods.

7392: Delete cascade feature is not supported in TMC.
Cause: Delete cascade feature is not supported.
Action: Do not use the delete cascade feature in TMC.

7393: Bucket number should be specified.
Cause: Bucket number should be specified on hash shading.
Action: Specify a bucket number from _DD_TABLET_MEMBER.

7394: Specified node number not found: %1$d.
Cause: Specified node number is not correct.
Action: Check node number by horde (show TMC).

7395: This DDL statement is only permitted in the massive cluster system.
Cause: In the single system, this DDL cannot be executed.
Action: Unable to execute.

7396: Delete set null feature is not supported in TMC.
Cause: Delete set null feature is not supported.
Action: Do not use the delete set null feature in TMC.

7397: Primary index on an IOT cannot be rebuilt.
Cause: Primary index on an IOT cannot be rebuilt.
Action: Use Alter table MOVE to reorganize the IOT.

7398: DDL alter system recompile was interrupted by other DDLs.
Cause: Try again.
Action: Try again.

7399: A partitioning key for an index-organized table must consist of one or more columns of a primary key.
Cause: One or more columns which are not included in a primary key were used for a partitioning key.
Action: Use a different partitioning key.

7400: Primary key constraints cannot be dropped, disabled, or deferred for index-organized tables.
Cause: An attempt was made to drop, disable, or defer a primary key constraint for an index-organized table.
Action: Do not drop, disable, or defer the primary key of index-organized tables.

7401: Invalid index option for an index-organized table.
Cause: An attempt was made to specify the REVERSE option for an index-organized table.
Action: Do not use the REVERSE option with index-organized tables.

7402: Invalid redefinition method: %1$s.
Cause: An attempt was made to specify an invalid redefinition method.
Action: OPTIONS_FLAG must be DBMS_REDEFINITION.CONS_USE_PK (1) or DBMS_REDEFINITION.CONS_USE_ROWID (2).

7403: Serial number of the target session is invalid. Serial#: %1$u
Cause: A valid serial number must be provided to apply a SESSION KILL request to a session.
Action: Check the session serial number.

7404: Status of the target session is not ACTIVE or RUNNING. Status: %1$d
Cause: SESSION KILL request can be only applied to a ACTIVE or RUNNING session.
Action: Check the session status.

7405: Unable to modify the primary key column value of an index-organized table.
Cause: Unable to modify the primary key column value of an index-organized table.
Action: Modify the column using the DBMS.REDEFINITION package.

7406: Unable to drop the primary key column of an index-organized table.
Cause: Unable to drop the primary key column of an index-organized table.
Action: Do not drop the primary key column of an index-organized table.

7407: Unable to execute this command while using Text-TIP.
Cause: Current database uses Text-TIP.
Action: Restart the server using btip.

7408: BTIP file open error: file is not found.
Cause: Verify the file name is valid.
Action: Verify the file name is valid.

7409: The BTIP extension name input is invalid.
Cause: Verify the BTIP file name.
Action: Verify the BTIP file name.

7410: The TIP extension name input is invalid.
Cause: Verify the TIP file name.
Action: Verify the TIP file name.

7411: A file with the same name already exists.
Cause: The specified file already exists.
Action: Unable to execute this command.

7412: Failed to create the file.
Cause: Ensure the file path and permissions are correct.
Action: For more information, check the errno in tracelog.

7413: Unable to decrease the column length because the column data will not fit in the new column length.
Cause: Unable to decrease the column length because the column data will not fit in the new column length.
Action: Use a larger column length.

7414: The data type conversion attempted is invalid.
Cause: There was an attempt to change the column type to an LOB type.
Action: Create a new column using an appropriate type and copy the data from the current column to the new column.

7415: A read-only table cannot be truncated.
Cause: An attempt was made to truncate a read-only table.
Action: Read-only tables cannot be truncated.

7416: Cannot alter the SYS account into a LOCK status.
Cause: There has been an attempt to change the SYS account into a LOCK status.
Action: Cannot execute the DDL statement.

7417: Error occurred while trying to refresh the materialized view “%1$s”.”%2$s”.
Cause: An unexpected error occurred due to an unknown reason while trying to refresh the materialized view (ec=%3$d).
Action: Check other error messages saved in the error stack.

7418: Auto increment is allowed only on one column in a table
Cause: More than one auto increment exists in the table.
Action: Specify only one auto increment column in the table.

7419: Cannot recompile “%1$s(%2$s)” while executing a parallel query.
Cause: Cannot recompile a PSM object while executing a parallel query.
Action: Serially execute the query, or retry after recompiling the invalid OBJ.

7420: The tablespace that the table belongs to is already encrypted.
Cause: Cannot perform the encryption operation for the encrypted tablespaces.
Action: Cannot perform the command.

7421: Cannot rename a materialized view.
Cause: Cannot rename a materialized view or its base table.
Action: Cannot execute the command.

7422: An index cannot be created from column of type ROWID.
Cause: An index cannot be made of ROWID type column.
Action: Unable to execute.

7423: Another session is using the temporary table, so this DDL operation cannot be performed.
Cause: This DDL statement can only be used when the temporary table is not being used by any other session.
Action: Check the session information for details about the session that is using the temporary table.

7424: INCREMENT must be less than MAXVALUE minus MINVALUE.
Cause: INCREMENT must be less than MAXVALUE minus MINVALUE.
Action: Unable to execute.

7425: IOT cannot be compressed.
Cause: The function has yet been implemented.
Action: The command cannot be run.

7426: This clause cannot be specified for the virtual table.
Cause: Tried to specify an invalid clause for the virtual table.
Action: Unable to execute this command.

7427: Specified tablespace ‘%1$s’ cannot be used as a user’s temporary tablespace.
Cause: The specified tablespace cannot be used for a temporary tablespace.
Action: Specify a different tablespace name.

7428: Status of the target session is not ASSIGNED and status of thread is not THR_STAT_WAITING
Cause: SESSION CLEAN request can be only applied to a ASSIGNED session.
Action: Check the session status.

7429: When creating global range partitioned index, the partition whose partitioning key columns’ values are all MAXVALUE should be specified.
Cause: When creating global range partitioned index, the values of the partitioning key columns of the last partition must all be MAXVALUE.
Action: Please check the value of the partitioning key columns.

7430: The specified value must be a positive integer greater than or equal to MINEXTENTS.
Cause: The specified value must be a positive integer greater than or equal to MINEXTENTS.
Action: Specify an appropriate value.

7431: The specified value must be a positive integer less than or equal to MAXEXTENTS.
Cause: The specified value must be a positive integer less than or equal to MAXEXTENTS.
Action: Specify an appropriate value.

7432: The memory space in the system is insufficient.
Cause: ERROR : malloc failed due to a lack of memory space in the system.
Action: Increase the memory space in the system.

7433: Duplicate ip ‘%1$s’ exists in LSNR_INVITED_IP.
Cause: IP already exists.
Action: Specify another IP.

7434: The datafile path(‘%1$s’) has no @SID@.
Cause: The absolute path of a datafile have to include @SID@ in TMC.
Action: Insert @SID@ into absolute path.

7435: The datafile path(‘%1$s’) is not correct.
Cause: The absolute path of a datafile is not correct.
Action: Please check the path of a datafile.

7436: IP address ‘%1$s’ is invalid.
Cause: An invalid IP address is given as a DDL paramter.
Action: Check the parameter and specify an appropriate value.

7437: Can’t exchange partition with the specified table.
Cause: Properties of the specified table is different with partition
Action: Change properties of the table.

7438: Failed to obtained the lock to refresh the materialized view “%1$s”.”%2$s”.
Cause: Another session is holding the lock.
Action: Try again later.

7439: Unable to perform DDL on the AQ table ‘%1$s’.
Cause: Unable to perform DDL on an AQ table.
Action: Confirm that the table the operation is to be performed on is an AQ table.

7440: The user defined error is called.
Cause: This error is called by the user defined error in PSM.
Action: Check the PSM that contains the user defined error.

7441: Objects other than tables cannot be flash backed.
Cause: Flashback operation attempts to flash back objects other than tables.
Action: Check the type of the object being flash backed.

7442: Flashback table is not allowed on this table.
Cause: The table is not supposed to be flash backed.
Action: Check whether the table is allowed to be flash backed.

7443: The specified remote database does not exist.
Cause: The specified remote database does not exist.
Action: Check the remote database name.

7444: Cannot make a remote container table for a DBMS remote database except for Tibero or Oracle.
Cause: The remote container table function of the materialized view is only supported for Tibero and Oracle.
Action: Confirm that the remote database is for Tibero or Oracle.

7445: Prebuilt table does not exist in the specified remote database position.
Cause: When using a remote database, only the ON PREBUILT TABLE option is supported.
Action: When creating a materialized view, use the statement “ON PREBUILT TABLE AT remote_database_name.”

7446: Prebuilt table does not exist in the specified remote database position.
Cause: Prebuilt table does not exist in the specified remote database position.
Action: When creating a materialized view, create a prebuilt table first.

7447: The rowid column does not exist in the prebuilt table at the specified remote database position.
Cause: To use REFRESH WITH ROWID when a remote database is specified, the column to store the rowid value must be manually created in the prebuilt table.
Action: Add the column (M_ROW$$ VARCHAR2(255)) to the prebuilt table, and then add a unique index to the column.

7448: cannot reuse lower-bound partitions resulting partition.
Cause: cannot reuse lower-bound partitions resulting partition.
Action: use upper_bound partition.

7449: range partitions being merged are not adjacent
Cause: range partitions being merged are not adjacent
Action: specify two partition that are adjacent

7450: The specified partition and table cannot be exchanged.
Cause: The table and the partition of the composite partition cannot be exchanged.
Action: Specify a subpartition.

7451: Cannot redefine an object online that is not a table
Cause: Cannot redefine an object online that is not a table
Action: Specify a table

7452: The specified plan table has incorrect format.
Cause: Cannot update the plan table because its format does not match the correct format.
Action: Make sure plan_table have the correct field definitions

7453: The specified thread ID is invalid.
Cause: An invalid thread ID given as a DDL parameter.
Action: Specify a valid thread ID as a DDL parameter.

7454: Datatype ‘%1$s.%2$s’ is invalid.
Cause: Specified data type is invalid, or the user-defined type does not exist.
Action: Please recheck the data type specified in the column.

7455: To use shrink space, row movement must be enabled for the object.
Cause: Cannot use shrink space on an object with disabled row movement.
Action: Enable row movement for the object.

7456: Cannot use shrink space on an object that has a long column.
Cause: Cannot use shrink space on an object that has a long column.
Action: Unable to execute this command.

7457: The interval value is not an appropriate constant type.
Cause: The interval value is invalid.
Action: Change the interval value to an appropriate type.

7458: The number of partition columns in the interval table is greater than one.
Cause: The number of partition columns in an interval table must be one.
Action: Set the number of partition columns to o

7459: The type of a partition column in the interval table is invalid.
Cause: The type of a partition column in an interval table must be NUMBER or DATE.
Action: Set the partition column type to NUMBER or DATE.

7460: Constraints do not match in “ALTER TABLE EXCHANGE PARTITION”.
Cause: The constraints of two tables do not match in “ALTER TABLE EXCHANGE PARTITION”.
Action: Please check the constraints.

7461: Invalid user name or role.
Cause: User name or role does not conform to a user rule.
Action: Check the user rule for CREATE USER.

7462: Cannot create an external table with a long column type.
Cause: At least one column has long type.
Action: Avoid using a long column type when creating an external table.

7463: The table “%1$s”.”%2$s” cannot be redefined online.
Cause: Online redefinition was attempted on tables that cannot be redefined such as temporary tables, the overflow table of an index-organization table, or tables where fine-grained access control or row-level security is enabled.
Action: Do not attempt online redefinition of tables that cannot be redefined online.

7464: INITRANS value is out of range.
Cause: The value of INITRANS is either too small or too large.
Action: Specify an integer value between 2 and 255.

7465: Cannot have a default value on a virtual column.
Cause: The virtual column is altered to have a default value.
Action: Remove the default value from the virtual column.

7466: Cannot have an expression on a real column.
Cause: The real column is altered to have an expression.
Action: Remove the expression from the real column.

7467: Cannot alter the primary index on an IOT unusable.
Cause: A primary key on an IOT cannot be unusable.
Action: Unable to execute.

7468: Bitmap index cannot be created on an IOT.
Cause: User attempted to create a bitmap index on an index-organized table.
Action: Unable to execute this command.

7469: Listener timeout.
Cause: Verify the port is valid.
Action: Verify the port is valid.

7470: Unable to add or delete listener port.
Cause: Verify the port is valid.
Action: Verify the port is valid.

7471: Cannot modify the default listener port. This port is currently in use internally.
Cause: Verify the port is valid.
Action: Verify the port is valid.

7472: Unable to add or delete listener port. Maximum number of ports was exceeded.
Cause: Verify the port is valid.
Action: Verify the port is valid.

7473: Unable to add or delete listener port. Port value is out of range (1024 – 65535).
Cause: Verify the port is valid.
Action: Verify the port is valid.

7474: The reference partitioning constraint is not found.
Cause: The constraint in reference partition is not one of foreign keys.
Action: Check if the reference partitioning constraint is defined as a foreign key.

7475: The parent table of the reference partition is not partitioned.
Cause: The reference partition can be created only if its parent table is partitioned.
Action: Check if the parent table referenced is partitioned.

7476: The option %1$s is invalid.
Cause: The specified option is invalid.
Action: Specify a valid option.

7477: The BTIP name input is invalid.
Cause: Verify the BTIP file name.
Action: Verify the BTIP file name.

7478: The TIP name input is invalid.
Cause: Verify the TIP file name.
Action: Verify the TIP file name.

7479: RENAME cannot be used in series.
Cause: Database cannot be renamed in series.
Action: Reboot to mount mode.

7480: Cannot alter a refence-partitioned table
Cause: A reference-partitioned table cannot be altered.
Action: Unable to execute this command.

7481: Cannot make SYS a client for a proxy user, or vice versa.
Cause: A proxy user option cannot be applied to SYS.
Action: Unable to execute this command.

7482: Index-Organized Table cannot include a LOB or LONG type column.
Cause: Index-Organized Table cannot include a LOB or LONG type column.
Action: Delete the LOB or LONG type column.

7483: The snapshot users to be compared not matched.
Cause: The user names of the snapshots are not the same.
Action: Check the user names of the snapshots.

7484: The change management package is not set up.
Cause: Some components of of change manage package are missing.
Action: Check the requirements of DBMS_CMGT package.

7485: Cannot create a snapshot for SYS user.
Cause: The dd snapshot for SYS user cannot be created.
Action: Try other users for snapshots.

7486: DBMS_CMGT not found.
Cause: Snapshot(s) or object(s) are not found.
Action: Check if inputs associated with snapshots are correct.

7487: Unable to shrink the temporary file %1$s (‘%2$s’ in tablespace ‘%3$s’).
Cause: Unable to shrink the temporary file.
Action: Check the properties of the temporary file.

7488: The value of ‘KEEP’ parameter is out of range.
Cause: The specified value of ‘KEEP’ paramter is either too small or too large.
Action: Check the parameter and specify an appropriate value.

7489: ADT is declared as a unique or primary key.
Cause: ADT cannot be declared as a unique or primary key.
Action: ADT cannot be declared as a unique or primary key.

7490: Index-Organized Table cannot include a ADT column.
Cause: Index-Organized Table cannot include a ADT column.
Action: Delete the ADT column.

7491: Current DDL is not allowed during instance recovery
Cause: Current DDL is not allowed during instance recovery
Action: Current DDL is not allowed during instance recovery

7492: ‘SYS._SGMT_BM_STAT_STATUS’ table does not exist.
Cause: ‘SYS._SGMT_BM_STAT_STATUS’ may be deleted or not be created.
Action: Contact the technical support team.

7493: ‘SYS._SGMT_BM_STAT_STATUS’ table already exists.
Cause: ‘SYS._SGMT_BM_STAT_STATUS’ table may be created by the previous same DDL that failed.
Action: Contact the technical support team.

7494: The specified segment does not exist.
Cause: The specified sgmt_id is invalid
Action: Specify a valid value and try again.

7495: The constraint column is not a REF column.
Cause: This constraint can only be specified on a REF column.
Action: Check the type of the constraint column.

7496: Multiple domain indexes cannot be created on a single column.
Cause: A domain index already exists on the specified column.
Action: Delete the existing domain index first.

7497: The specified type is missing the %1$s member function.
Cause: An attempt was made to bind the type without the %1$s member function.
Action: Add the %1$s member function to the type.

7498: Package body recompile failed by invalid package spec.
Cause: Package body recompile failed by invalid package spec.
Action: Try again.

7500: Recompile failed by other DDL. Try again.
Cause: Recompile failed by other DDL. Try again.
Action: Try again.

7501: Not allowed in standby replication.
Cause: Not supported in standby replication.
Action:

7502: Remote Information of %1$s is missing.
Cause: Remote Information is needed.
Action: Specify Remote Information.

7503: Cannot export/import data files from TAS to None TAS due to ‘+’.
Cause: Cannot export/import data files from TAS to None TAS due to ‘+’.
Action: Do not use prefix ‘+’ when exporting/importing data files from TAS to NONE TAS.

7504: Cannot set undo_tablespace parameter while setting others.
Cause: Set undo_tablespace parameter exclusively.
Action: Set undo_tablespace parameter exclusively.

7505: Tablespace is already default tablespace.
Cause: Check tablespace name.
Action: Chekc tablesapce name.

7506: This command is allowed for only SYS user.
Cause: This command is allowed for only SYS user.
Action: Login as SYS user and try again.

7507: Cannot create/add context local partition(s) index with more than 127 partitions.
Cause: The maximum local partition count allowed for context index is 127.
Action: Check the partition count for the table.

7508: Unable to shrink permanent tablespace.
Cause: Shrink space is not allowed on non-temporary tablespace.
Action: Check the type of tablespace.

7509: cannot grant ‘%1$s’ to a role.
Cause: cannot grant ‘%1$s’ to a role.
Action: cannot grant ‘%1$s’ to a role.

7510: Old password file exists. Unable to create new password file.
Cause: Move(or remove) the old password file before newmounting database.
Action: Move(or remove) the old password file before newmounting database.

7512: Not permitted while standby database is enabled.
Cause: The action is not permitted while the standby DB is enabled.
Action: Disable the standby DB and try again.

7513: Both bitmap index and unique key cannot co-exists.
Cause: Choose bitmap index or unique constraint.
Action: Choose bitmap index or unique constraint.

7514: The standby is not RUNNING status.
Cause: The action is not permitted while the standby DB is not RUNNING.
Action: Wait for complete operation of booting the standby.

7515: At least one LGWR SYNC standby DB is required.
Cause: At least one LGWR SYNC standby DB is required.
Action: At least one LGWR SYNC standby DB is required.

7516: The LNW is not ready to start.
Cause: The LNW is not ready to start.
Action: The LNW is not ready to start.

7517: Must specify table name for nested table column or attribute.
Cause: Nested table column or attribute is not specified on the storage clause.
Action: Specify the nested table storage clause.

7518: XMLSchema ‘%1$s’ is not registered.
Cause: XMLSchema is not registered before creating table.
Action: Register XMLSCHEMA first.

7519: Tag name ‘%1$s’ in XMLSchema ‘%2$s’ is invalid.
Cause: Tag name is not invalid.
Action: Check XMLSCHEMA.

7520: Referential constraint is not allowed on nested table column.
Cause: Referential constraint is not allowed on nested table column.
Action: Unable to execute.

7521: Specified column ‘%1$s’ is not a nested table type.
Cause: Specified column type is invalid for nested table.
Action: Check the specified column type or nested table storage clause.

7522: DDL need retry.
Cause: DDL need retry as DDL cannot proceed.
Action: DDL need retry.

7523: Memory tablespace already exists.
Cause: Memory tablespace already exists.
Action: Drop the existing memory tablespace first.

7524: Memory tablespace cannot have datafiles more than ‘%1$d’.
Cause: Memory tablespace has too many datafiles.
Action: Check the number of datafiles.

7525: No free space for memory tablespace.
Cause: The size of memory tablespace exceeds the maximum size allowed.
Action: Check the size of memory tablespace.

7526: The size of Memory tablespace is undefined.
Cause: The size of Memory tablespace is undefined.
Action: Check MEMORY_TABLESPACE_SIZE parameter.

7527: Fail to invalidate cursors due to missing pp main info.
Cause: Fail to invalidate cursors due to missing pp main info.
Action: Invalidate all existing PP cache.

7528: Memory tablespace cannot have auto-extended datafiles.
Cause: Memory tablespace cannot have auto-extended datafiles.
Action: Check the datafile spec.

7529: Memory tablespace cannot be offline.
Cause: Memory tablespace cannot be offline.
Action: Unable to execute.

7530: Sdisk member clause required.
Cause: Sdisk member clause is missing.
Action: Specify an Sdisk member clause.

7531: Gdisk member clause required.
Cause: Gdisk member clause is missing.
Action: Specify a Gdisk member clause.

7532: SFC member clause required.
Cause: SFC member clause is missing.
Action: Specify an SFC member clause.

7533: IORM member clause required.
Cause: IORM member clause is missing.
Action: Specify an IORM member clause.

7534: A table can have only one identity column.
Cause: A table may have only one identity column.
Action: Specify one identity column.

7535: Identity column can be created only on a column of numeric type.
Cause: Identity column is not a numeric type.
Action: Identity column be a numeric type.

7536: Invalid NOT NULL constraint uesd on and identity column.
Cause: A NOT NULL constraint was not used properly on an identity column.
Action: Identity column with a NOT NULL constraint must be enabled and nondeferrable.

7537: INVALID trigger in FOLLOWS option.
Cause: INVALID trigger in FOLLOWS option.
Action: Check FOLLOWS option.

7538: Materialized view ‘%1$s’ cannot be dropped internally.
Cause: Materialized view cannot be dropped internally.
Action: Drop materialized view ‘%1$s’ externally and retry drop user.

7539: Cannot include an LOB column in a compressed table.
Cause: LOB column is not supported in compressed tables.
Action: Modify the DDL statement.

7540: Multiple datafiles specified for bigfile tablespace.
Cause: A bigfile tablespace can contain only one datafile.
Action: Check the number of datafiles specified for the bigfile tablespace.

7541: Failed to backup archive logfiles due to another archive logfile backup ongoing.
Cause: Failed to backup archive logfiles due to another archive logfile backup ongoing.
Action: Please use ‘–archive-only’ or ‘–with-archivelog’ only when another ongoing doesn’t exist.

7542: Failed to backup due to none of the RECO slaves are free to use.
Cause: Failed to backup due to none of the RECO slaves are free to use.
Action: Please retry with smaller value of ‘-p, –parallel’ option (max. %1$d).

7543: Another RMGR datafile backup/restore/delete job already ongoing.
Cause: Cannot execute more than one RMGR datafile backup/restore/delete job at a time.
Action: Please retry after the ongoing RMGR finishes.

7544: Lob columns do not match in “ALTER TABLE EXCHANGE PARTITION”.
Cause: The lob columns of two tables do not match in “ALTER TABLE EXCHANGE PARTITION”.
Action: Please check the lob columns.

7545: Failed to add backup archivelog due to no backup archivelog in the backup set.
Cause: Actual backup set doesn’t contain the archivelog backups.
Action: Please check the query for adding the archivelog backups.

7546: There is no visible column in the table.
Cause: A table must have at least one visible column.
Action: Please check the visibility of the columns in the table.

7547: Data integrity is violated.
Cause: Query result from index scan is different from that from table scan
Action: Please check the physical plan dump and log.

7548: A column to be modified is not an identity column.
Cause: The specified column cannot be identity column.
Action: Make sure that the column to be modified to identity column is an identity column.

7549: Failed to backup/delete archive logfiles due to another archive logfile backup/delete ongoing.
Cause: Failed to backup/delete archive logfiles due to another archive logfile backup/delete ongoing.
Action: Please retry only when another archive logfile backup/delete is not ongoing.

7550: Failed to execute RMGR backup due to another RMGR backup already ongoing.
Cause: Failed to execute RMGR backup due to another RMGR backup already ongoing.
Action: Please retry after the ongoing RMGR backup finishes.

7551: Invalid COMPRESS prefix length value
Cause: The prefix length value must be an integer between 1 and the number of key columns (number of key columns – 1 for unique index).
Action: Retry with a valid prefix length value.

7552: Cannot use COMPRESS option for a single column key
Cause: A single column unique index cannot be compressed.
Action: Retry with a valid prefix length value.

7553: Cannot use %1$s as a lob segment name.
Cause: You cannot use SECUREFILE or BASICFILE as a lob segment name.
Action: Retry with a valid lob segment name.

7554: Cannot enforce to use specified types of index for constraint.
Cause: The specified type of index cannot be enforced to use as a constraint.
Action: Check the type of the specified index.

7555: Cannot use supplemental logging and nologging together.
Cause: Supplemental logging cannot be used together with nologging.
Action: Retry after changing the object status or modifying the statement.

7556: Cannot create a unique local partitioned index on a system partitioned table.
Cause: A unique local partitioned index cannot be created on a system partitioned table.
Action: Create a non-unique index or change the index partition option.

7557: Cascading standby only supports PERFORMANCE mode.
Cause: Cascading standby only supports PERFORMANCE mode.
Action: Cascading standby only supports PERFORMANCE mode.

7558: Cascading standby only supports ASYNC log transport mode.
Cause: Cascading standby only supports ASYNC log transport mode.
Action: Cascading standby only supports ASYNC log transport mode.

7559: instance id of the target session is invalid or failed to send a request to target instance. instance_id: %1$u
Cause: A valid instance id must be provided to apply a SESSION KILL request to a session.
Action: Check the instance id or status of the target instance.

7560: The tablespace (id: %1$s) is online.
Cause: The tablespace must be offline.
Action: Please retry after offline the tablespace.

7561: dependent object “%1$s”.”%2$s” already registered
Cause: You cannot register an already registered dependent object.
Action: Check the name of the dependent object.

7562: Partitioned table specified as target table for exchange statement.
Cause: The target table for an exchange statement must be a non-partitioned table.
Action: Specify a non-partitioned table.

7563: Cannot alter temporary tablespace.
Cause: You cannot alter the temporary tablespace because it is currently in use.
Action: Retry the operation when the temporary tablespace becomes available.

7564: LOG_REPLICATION_DEST_%1$d is already %2$s.
Cause: LOG_REPLICATION_DEST_%1$d is already %2$s.
Action: Check the status of log replication destination.

7565: Too many columns in a table with a UDT column.
Cause: A table with a UDT column can have up to 255 columns.
Action: Modify the CREATE TABLE statement.

7566: Cannot reverse a bitmap index.
Cause: Bitmap indexes cannot be reversed. This operation is not supported.
Action: Modify the DDL statement.

7568: Cannot execute ‘alter session current schema’ in trigger.
Cause: This operation is not supported here.
Action: ‘alter session current schema’ is not allowed to execute in ddl trigger.

7569: Another RMGR archivelog backup/restore/delete job already ongoing.
Cause: Cannot execute more than one RMGR archivelog backup/restore/delete job at a time.
Action: Please retry after the ongoing RMGR finishes.

7570: Another Media Recovery or RMGR job is already ongoing.
Cause: Cannot execute RMGR and Media Recovery at the same time.
Action: Retry one at a time.

7571: A duplicate column expression was specified.
Cause: The expression of a virtual column being created conflicts with an existing index expression or a virtual column expression.
Action: Change the expression to a unique virtual column expression.

7572: A virtual column for this expression already exists.
Cause: “%1$s” matches an existing virtual column.
Action: Replace the expression used for indexes with the matching virtual column and then try again.

7573: The specified virtual database ‘%1$s’ does not exist.
Cause: The specified virtual database does not exist.
Action: Specify a valid virtual database and try again.

7574: The name ‘%1$s’ is already used by another virtual database or remote database.
Cause: The specified virtual database name is already in use.
Action: Specify another virtual database name.

7575: Cannot purge LOB indexes.
Cause: Purging LOB indexes is not allowed.
Action: Check the index name.

7576: Cannot shrink file %1$s because it is being backed up or copied.
Cause: The datafile is involved in an online backup.
Action: Check if the end backup has been completed. Try again after the online backup is complete.

7577: Media Recovery without for standby option is not allowed in standby replication.
Cause: Media Recovery without for standby option is not allowed in standby replication.
Action: Retry media recovery with for standby option.

7578: Media Recovery with for standby option is not allowed if the database is not standby replication.
Cause: Media Recovery with for standby option is not allowed if the database is not standby replication.
Action: Retry media recovery without for standby option.

7579: The virtual column is referenced in a column expression.
Cause: The virtual column is referenced in an expression of another virtual column.
Action: Make sure that the column expression definition for the virtual column does not refer to any other virtual column.

7580: Virtual columns are not allowed in functional index expressions.
Cause: One or more virtual columns were used to define the expression of a functional index.
Action: Specify the index expression using only regular columns.

7581: The column to be dropped or modified is used in a virtual column expression.
Cause: A column used in a virtual column expression cannot be dropped or modified.
Action: Drop the virtual column first or change the virtual column expression to eliminate dependency on the column to be dropped.

7582: The column to be renamed is used in a virtual column expression.
Cause: A column used in a virtual column expression cannot be renamed.
Action: Drop the virtual column first or change the virtual column expression to eliminate dependency on the column to be renamed.

7583: Cannot access the sequence ‘%1$s’ in use.
Cause: The sequence has been dropped or attempted to be dropped in another session.
Action: Check whether the sequence exists and retry.

7584: Media Recovery with _STANDBY_ALLOW_TEMPFILE_ADD_IN_MOUNT_MODE=Y is not allowed.
Cause: Media Recovery with _STANDBY_ALLOW_TEMPFILE_ADD_IN_MOUNT_MODE=Y is not allowed..
Action: Set _STANDBY_ALLOW_TEMPFILE_ADD_IN_MOUNT_MODE=N and retry media recovery.

7585: The %1$s cannot be %2$s than the current value.
Cause: The next value or start value must be between MINVALUE and MAXVALUE.
Action: Specify MINVALUE or MAXVALUE within the valid range.

7586: The number of partitions of the reference-partitioned table is different from that of the parent table.
Cause: The number of partitions of the reference-partitioned table is different from that of the parent table.
Action: Check the CREATE TABLE statement.

7587: The reference partitioning constraint is not supported.
Cause: The reference partitioning constraint is not supported.
Action: Correct the reference partitioning constraint.

7588: The reference partitioning key is not supported.
Cause: The reference partitioning key is not supported.
Action: Correct the reference partitioning key.

7589: The parent table of the reference-partitioned table is an index-organized table.
Cause: A reference-partitioned table is not supported for an index-organized table.
Action: Check the CREATE TABLE statement.

7590: The partitioning method is not supported for an index-organized table.
Cause: The partitioning method is not supported for an index-organized table.
Action: Check the CREATE TABLE statement.

7591: Failed to set LOG_REPLICATION_DEST_%1$d: %2$s
Cause: Invalid LOG_REPLICATION_DEST_%1$d.
Action: Check the LOG_REPLICATION_DEST_%1$d and retry.

7592: Tablespace cannot be dropped because invalid _DD_FILE row found.
Cause: Tablespace cannot be dropped because invalid _DD_FILE row found.
Action: Contact the technical support team.

7593: An unusable index exists on the constraint key.
Cause: An unusable index exists on the constraint key.
Action: Drop the unusable index or rebuild it using ALTER INDEX REBUILD.

7594: The operation is not supported for reference-partitioned tables.
Cause: The operation is not supported for reference-partitioned tables.
Action: Do not perform the unsupported operation.

7595: Indexes and their index partitions must have the same compression attribute.
Cause: The user attempted to exchange an index with an index partition using different compression attributes.
Action: Make sure that the compression attributes match. If they don’t, drop and rebuild the index with the same compression attribute.

7596: Virtual columns were used as supplemental log columns.
Cause: Virtual columns are not supported in supplemental log columns.
Action: Exclude virtual columns from the supplemental log column group.

7597: Failed to create controlfile because MAXINSTANCES and IPARAM(MAX_INSTANCE_COUNT) did not match.
Cause: Failed to create controlfile because MAXINSTANCES and IPARAM(MAX_INSTANCE_COUNT) did not match.
Action: Modify the value of MAXINSTANCES or IPARAM(MAX_INSTANCE_COUNT) and try again.

7598: The index type is unsupported for the operation.
Cause: The index type is unsupported for the operation.
Action: Check the index type.

7599: The name of the text index is too long.
Cause: The name of the text index exceeds the maximum allowed length.
Action: Change the name of the text index.

7600: Already enabled sequence scalability cannot be turned off.
Cause: Already enabled sequence scalability cannot be turned off.
Action: If the option needs to be changed to NO SCALE, DROP and CREATE the sequence.

7601: The data type of the virtual column is not supported.
Cause: The data type of the specified expression is not supported in virtual columns. Only scalar data types are supported for virtual columns. LONG, LOB, OBJECT, REF and VARRAY data types are not supported for virtual columns.
Action: Specify the virtual column expression to return a scalar data type.

7602: Cannot specify a monthly interval with existing upper limits whose number of days is greater than 28.
Cause: The specified interval conflicts with the existing upper limit for the last partition. This combination may result in invalid dates for upper limits in the future.
Action: If this is a CREATE TABLE, try specifying a different upper limit for the last partition or a different interval. If this is an ALTER TABLE SET INTERVAL, choose either a different interval or modify the table to change the upper limit for the last partition.

7603: Table is not partitioned by Interval method.
Cause: The table was not partitioned by the Interval method.
Action: ALTER TABLE SET STORE IN is only valid for Interval partitioned tables. Check if the table is an Interval partitioned table.

7604: SET INTERVAL or SET STORE IN is invalid in this table.
Cause: SET INTERVAL or SET STORE IN clause was specified. ALTER TABLE SET INTERVAL or ALTER TABLE SET STORE IN is only valid on a range partitioned table with a single partitioning column. Additionally, this table cannot have a maxvalue partition and cannot be the parent table for any reference partitioned table.
Action: Use SET INTERVAL or SET STORE IN only on a valid table.

7605: Interval cannot be zero.
Cause: This interval was mapped to zero.
Action: You must use a non-zero interval.

7606: Cannot grant ts_quota on the tablespace.
Cause: It is not possible on grant ts_quota in UNDO or TEMP tablespaces.
Action: Check the tablespace to grant ts_quota.

7607: Cannot open database to NORMAL mode due to %1$s.
Cause: It is not possible to open database due to %1$s.
Action: Check the condition to open the database.

7608: Unavailable to rename system/undo files on NORMAL mode.
Cause: It is not possible to rename system or undo files on NORMAL mode.
Action: Try renaming it on MOUNT mode.

7609: Cannot use the PROFILE option in the current configuration for the user DDL.
Cause: The PROFILE option cannot be used without the USE_PROFILE parameter.
Action: Check the USE_PROFILE parameter.

7610: Unique keyword is not allowed for domain index.
Cause: An attempt was made to domain index with unique option.
Action: Remove unique keyword from create index ddl.

7611: An invalid ALTER TABLE option was specified for an index-organized table.
Cause: The ALTER TABLE option is not valid for an index-organized table.
Action: Remove the invalid option.

7612: TCC table cannot include a %1$s type column.
Cause: TCC table cannot include a %1$s type column.
Action: Delete the %1$s type column.

7613: Compressed table cannot include a LONG type column.
Cause: A LONG type column added to compressed table.
Action: Do not specify a LONG type column.

7614: The schema name ‘%1$s’ is invalid.
Cause: The schema name ‘%1$s’ is invalid.
Action: Specify a valid schema name.

7615: Restart option is not allowed for create sequence
Cause: Restart option is not allowed for create sequence
Action: Remove restart option

7616: In-memory tables cannot be compressed.
Cause: Compressing in-memory tables is not supported.
Action: Unable to process.

7617: During a table redefinition, it is not possible to specify a column in an interim table that is mapped to the original table.
Cause: Such action is not supported.
Action: Retry after removing the parameter.

7618: The external table cannot be used for redefinition.
Cause: External tables cannot be used as an original table or interim table for redefinition.
Action: Unable to process.

7619: The partitioned table cannot be redefined online.
Cause: Online redefinition was attempted on partitioned tables that cannot be redefined such as tables containing lob type column, index-organized tables or tables consist of subpartitions.
Action: Do not attempt online redefinition of partitioned tables that cannot be redefined online.

7620: The table cannot be used as an interim table for table redefinition.
Cause: Partitioned tables cannot be used as an interim table for partition redefinition.
Action: Unable to process.

7621: Cannot redefine due to redundant names of table and constraint.
Cause: The table and constraint have the same name.
Action: Unable to process.

7622: Cannot move the table to another tablespace.
Cause: Partitioned tables, virtual tables, index-organized tables, system tables, global temporary tables, or tables with xml indexes cannot be moved.
Action: Unable to process.

7623: Cannot use TCC Compression on unsupported storage.
Cause: An attempt was made to use TCC Compression on unsupported storage.
Action: Create this table while using ZetaData.

7624: A partition containing a usable local context index cannot be exchanged with another table.
Cause: The partition cannot be exchanged because it holds a usable local context index.
Action: Ensure that the local context index is unusable to exchange the partition, and then rebuild the local context index.

7625: Unable to add or delete listener ip.
Cause: Verify the ip is valid.
Action: Verify the ip is valid.

7626: Unable to add or delete listener ip. Maximum number of ips was exceeded.
Cause: Verify the ip is valid.
Action: Verify the ip is valid.

7627: Cannot alter type rename attribute to same name ‘%1$s’.
Cause: An attempt was made to change attribute name to same name.
Action: Rename attribute to different name.

7628: Cannot find attribute name ‘%1$s’.
Cause: The attribute name ‘%1$s’ is not found from the object type.
Action: Specify the attribute name correctly.

7629: Duplicate attribute name ‘%1$s’ exists.
Cause: The attribute name ‘%1$s’ is already found in the object type.
Action: Rename attribute to different name.

7630: Failed to compile the type.
Cause: The use of the ALTER TYPE statement caused a compilation error.
Action: Correct the error reported and resubmit the statement.

7631: Cannot do this ALTER TYPE operation to collection types.
Cause: This ALTER TYPE operation is only valid for object types.
Action: Specify a valid object type name.

7632: Cannot alter a type that is not valid.
Cause: An attempt was made to perform ALTER TYPE on an invalid type.
Action: Use the CREATE OR REPLACE TYPE command to modify the type.

7633: Method ‘%1$s’ does not have matching signature among existing methods.
Cause: The method to be dropped does not match to any existing method.
Action: Make sure that a matching method signature is provided for dropping a method.

7634: Cannot ADD or DROP values to the DEFAULT partition.
Cause: Values of the DEFAULT partition cannot be added or dropped.
Action: Do not modify any values of the DEFAULT partition.

7635: DEFAULT cannot be used for ADD or DROP VALUES statements.
Cause: An attempt was made to add or drop DEFAULT value.
Action: ADD or DROP PARTITION containing DEFAULT instead of modifying the partition.

7636: Values already exist in the partition ‘%1$s’.
Cause: Cannot add or drop values existing in the partition.
Action: If necessary, delete rows containing corresponding values before ADD/DROP values of the partition.

7637: ‘%1$s’ does not exist in the partition ‘%2$s’.
Cause: Cannot drop the partition values because the values do not exist in the partition.
Action: Drop values that exist in the partition.

7638: Cannot drop all partition values.
Cause: An attempt was made to drop all values of the partition.
Action: This command cannot be executed.

7639: Cannot alter the SYS account into an UNLOCK status in SOD.
Cause: There has been an attempt to change the SYS account into an UNLOCK status.
Action: Cannot execute the DDL statement.

7640: Unable to DROP or REPLACE the object due to an existing dependency.
Cause: The object has a dependency on another table.
Action: DROP the dependent table or use the FORCE option.

---

Tibero Error Message 8000~8999

8002: Invalid DML statement.
Cause: The statement is not a valid DML (Data Manipulation Language) statement.
Action: Check the syntax.

8003: Unable to execute DML statement.
Cause: Unable to execute the DML statement.
Action: Check if DML is executable in the current DB state.

8004: Syntax error.
Cause: There is a syntax error.
Action: Check the statement syntax.

8005: Identifier is too long.
Cause: The identifier is too long.
Action: Adjust the length to less than 30 characters.

8006: Missing FROM keyword.
Cause: The FROM keyword is missing.
Action: Check the statement syntax.

8007: Missing boolean expression.
Cause: A conditional expression is missing or contains syntax errors.
Action: Check the statement syntax.

8008: Missing expression.
Cause: Invalid or missing expression.
Action: Check the expression syntax.

8009: Missing keyword.
Cause: There is a syntax error.
Action: Check the statement syntax.

8010: Missing INTO keyword.
Cause: INTO keyword is missing.
Action: Check the statement syntax.

8011: Missing VALUES keyword.
Cause: VALUES keyword is missing.
Action: Check the statement syntax.

8012: Missing comma.
Cause: A comma is missing.
Action: Check the statement syntax.

8013: Missing SELECT keyword.
Cause: SELECT keyword is missing.
Action: Check the statement syntax.

8014: Missing NULL keyword.
Cause: NULL keyword is missing.
Action: Check the statement syntax.

8015: Missing right parenthesis.
Cause: Right parenthesis is missing.
Action: Check the statement syntax.

8016: Missing BY keyword.
Cause: BY keyword is missing after the ORDER, GROUP or CONNECT keyword.
Action: Check the statement syntax.

8017: Missing CONNECT BY clause.
Cause: In a hierarchical query, the CONNECT BY clause should be specified.
Action: Check the statement syntax.

8018: Missing equal sign.
Cause: In a SET clause, an “=” is missing.
Action: Check the statement syntax.

8019: Missing WITH keyword.
Cause: WITH keyword is missing after a START keyword.
Action: Check the statement syntax.

8020: Missing SET keyword.
Cause: In an UPDATE statement, a SET clause is missing.
Action: Check the statement syntax.

8021: Invalid table name.
Cause: The specification of the table, view or inline view in the FROM clause uses invalid syntax.
Action: Check the statement syntax.

8022: Invalid end of SQL.
Cause: The SQL statement is invalid.
Action: Check the statement syntax.

8023: Invalid qualifier specification.
Cause: Invalid qualifier specification.
Action: Check the qualifier syntax.

8024: Duplicate derived column name exists.
Cause: A derived column with this name already exists.
Action: Rename the column.

8025: Number of derived columns and table columns do not match.
Cause: The number of derived columns does not match the number of columns in a base table, view or inline view.
Action: Modify the query.

8026: Invalid identifier.
Cause: Unable to interpret the column or identifier.
Action: Check the identifier.

8027: Column name is ambiguous.
Cause: Columns with the same name exist in more than one table, view or inline view.
Action: Specify a qualifier for the column name.

8028: FOR UPDATE clause is not allowed here.
Cause: The FOR UPDATE clause was used in a SELECT query block other than the top one.
Action: Check the query block syntax.

8029: FOR UPDATE clause is not allowed for this query.
Cause: The FOR UPDATE statement cannot be used in a query that uses GROUP BY, DISTINCT or set functions.
Action: Modify the query.

8030: Not enough values.
Cause: The number of expressions specified in a VALUE statement is less than the number of columns.
Action: Ensure that the numbers match.

8031: Too many values.
Cause: The number of expressions specified in a VALUE statement is greater than the number of columns.
Action: Ensure that the numbers match.

8032: ORDER BY position must be the same as an entry number in a SELECT-list expression.
Cause: The position specified in ORDER BY clause is out of range.
Action: Specify a valid position.

8033: Specified schema object was not found.
Cause: The specified schema object does not exist.
Action: Check the schema object name.

8034: Specified sequence was not found.
Cause: The sequence does not exist.
Action: Check the sequence name.

8035: Specified synonym was not found.
Cause: The synonym does not exist.
Action: Check the synonym name.

8036: Specified procedure or function was not found.
Cause: Procedure or function does not exist.
Action: Check the procedure name.

8037: Invalid use of group functions.
Cause: Set functions cannot be used in SELECT LIST, HAVING, or ORDER BY clauses.
Action: Check the statement syntax.

8038: Expression is not in a GROUP BY clause.
Cause: An expression that was not specified in a GROUP BY clause was used.
Action: Modify the query.

8039: The ORDER BY clause must contain constants or SELECT list expressions.
Cause: When DISTINCT is specified in a SELECT LIST clause, it must be used in an ORDER BY clause.
Action: Modify the query.

8040: Duplicate column name exists.
Cause: A column name is used more than once.
Action: Modify the query.

8041: Invalid table reference.
Cause: In a FROM clause, schema objects other than tables and views cannot be used.
Action: Modify the query.

8042: Outer join operator (+) cannot be used in a clause with a subquery.
Cause: Sub queries cannot be used along with the outer join condition.
Action: Modify the query.

8043: Outer join operator (+) cannot be used in a clause with OR.
Cause: The OR operator cannot be used along with the outer join condition.
Action: Modify the query.

8044: Outer join operator (+) cannot be used in a clause with IN.
Cause: The IN operator cannot be used along with the outer join condition.
Action: Modify the query.

8045: Outer join operator (+) cannot be used on both sides simultaneously.
Cause: Outer joining of two tables is not allowed.
Action: Delete one of the outer join conditions.

8046: Outer join operator (+) cannot be used between more than two tables.
Cause: Outer joining between more than two tables is not allowed.
Action: Modify the query.

8047: Outer join operator (+) cannot be used with ANSI joins.
Cause: Outer joins cannot be used with ANSI joins.
Action: Modify the query.

8048: Virtual table (dynamic performance view) cannot be updated.
Cause: An attempt was made to update virtual table.
Action: Virtual table cannot be updated.

8049: The ORDER BY clause in a SET clause is invalid: use ordinal numbers.
Cause: In an ORDER BY clause in a query where SET the operator was used, invalid expressions were used.
Action: Modify the query.

8050: Procedures are prohibited in the DML expression.
Cause: Procedure cannot be used in DML statement.
Action: Unable to use procedure.

8051: User-defined functions are not permitted in the expression.
Cause: Functions cannot be used in a CALL clause which requires a procedure.
Action: Use a valid procedure.

8052: Invalid object status.
Cause: The current object is disabled.
Action: Recreate the object.

8053: Not authorized.
Cause: An attempt was made to access unauthorized objects or columns.
Action: Unable to access the object.

8054: Subquery cannot be used in GROUP BY clause.
Cause: Subquery cannot be used in GROUP BY clause.
Action: Modify the query.

8055: The number of expressions in the RETURNING clause and the number of INTO columns do not match.
Cause: The number of expressions specified in the RETURNING clause and that of columns to be updated do not match with each other.
Action: Modify the query.

8056: Invalid number of columns in query.
Cause: The number of PROJECTIONs between blocks used in SET operation do not match.
Action: Modify the query.

8057: Columns are non-updatable.
Cause: The column cannot be updated.
Action: Check whether or not the column is in a key-preserved table.

8058: Too many key-preserved tables specified.
Cause: More than two key-preserved tables cannot be updated at once.
Action: Modify the query to update only one key preserved table.

8059: A key-preserved table was not found.
Cause: The view cannot be updated.
Action: Check whether or not it is a key-preserved table.

8060: A deletable table was not found.
Cause: A key preserved table, which can be deleted, does not exist in view.
Action: Check the definition of the view.

8061: Columns in USING clauses or NATURAL joins cannot have a qualifier.
Cause: Columns in USING clauses or NATURAL joins cannot have a qualifier.
Action: Delete the qualifier.

8062: Nesting level of aggregation functions is too deep.
Cause: The nesting level of aggregation functions is too deep.
Action: Modify the query.

8063: LONG columns are not permitted.
Cause: LONG type columns cannot be used.
Action: Modify the query.

8064: LOB columns are not permitted.
Cause: LOB type columns cannot be used.
Action: Modify the query.

8065: Invalid host variable name.
Cause: An invalid host variable name was used.
Action: Ensure the host variable name uses proper syntax.

8066: Circular view detected.
Cause: View definition cannot reference itself.
Action: Check the view definition.

8067: Invalid window value used in analytic clause.
Cause: Invalid window range expression in analytic function.
Action: Modify the query.

8068: ORDER BY cannot be used here.
Cause: The ORDER BY clause cannot be used in a subquery.
Action: Modify the query.

8069: Invalid single-group group function.
Cause: Columns which are not used in a GROUP BY clause are used outside aggregation functions.
Action: Change the query.

8070: Subqueries are not allowed in SELECT LIST clauses that use nested aggregation.
Cause: SELECT LIST clauses that use the nested aggregation function cannot use subqueries.
Action: Delete the subquery.

8071: Partition name cannot be used with view.
Cause: View cannot use partition name.
Action: Delete the partition name.

8072: Subqueries cannot be used in this clause.
Cause: A subquery cannot be used in DEFAULT, CHECK or RETURNING clauses.
Action: Delete the subquery.

8073: UDF cannot be used in this clause.
Cause: UDF cannot be used in DEFAULT or CHECK clauses.
Action: Modify the query.

8074: Sequence cannot be used here.
Cause: Sequence being is used in an invalid position.
Action: Modify the query.

8075: ROWNUM cannot be used in this clause.
Cause: ROWNUM cannot be used in DEFAULT or CHECK clauses, or as a join condition.
Action: Modify the query.

8076: LEVEL cannot be used in this clause.
Cause: LEVEL cannot be used in DEFAULT or CHECK clauses.
Action: Modify the query.

8077: Bind variable cannot be used in this clause.
Cause: The bind variable cannot be used in DEFAULT or CHECK clauses.
Action: Modify the query.

8078: Aggregation function cannot be used in this clause.
Cause: The aggregation function cannot be used in DEFAULT or CHECK columns.
Action: Modify the query.

8079: Analytic function cannot be used in this clause.
Cause: The analytic function cannot be used in DEFAULT clauses, CHECK clauses, and in index columns.
Action: Modify the query.

8080: PRIOR keyword cannot be used in this clause.
Cause: PRIOR keyword can be used only in a CONNECT BY clause.
Action: Modify the query.

8081: Column cannot be used in this clause.
Cause: Column cannot be used in DEFAULT or VALUES clauses.
Action: Modify the query.

8082: Non-deterministic functions, date or system variables cannot be used in this clause.
Cause: Non-deterministic functions cannot be used in DEFAULT clauses, CHECK clauses, and in index columns.
Action: Modify the query.

8083: Table is not partitioned.
Cause: PARTITION or SUBPARTITION keywords cannot be used in non-partitioned tables.
Action: Modify the query.

8084: The specified partition does not exist.
Cause: Unable to find the partition name.
Action: Check the partition name and retry.

8085: The specified sub-partition does not exist.
Cause: Unable to find the sub-partition name.
Action: Check the sub-partition name and retry.

8086: %1$s is not supported.
Cause: The syntax is not supported by the current version.
Action: Modify the query.

8087: Invalid SET clause.
Cause: The expression in a SET clause is incomplete.
Action: Correct the expression.

8088: View %1$s has errors.
Cause: View definition, referenced schema object or authority check has errors.
Action: Correct the error.

8089: Tuple expression must have a degree of 2.
Cause: Invalid number of argument of the OVERLAP function.
Action: Verify the use of the OVERLAP function.

8090: Invalid bind variable name.
Cause: Bind variable names starting with ‘:SYS_B_’ cannot be used.
Action: Change the name.

8091: INSERT/UPDATE/DELETE cannot be performed on tables with constraints (%1$s.%2$s) in the DISABLE VALIDATE state.
Cause: An attempt was made to execute INSERT/UPDATE/DELETE on a table with constraints in a DISABLE VALIDATE state.
Action: Modify the constraints condition.

8092: SIBLINGS keyword cannot be used in this clause.
Cause: SIBLINGS cannot be specified in the ORDER BY clause.
Action: Modify the query.

8093: INTO clauses cannot be used here.
Cause: INTO and BULK COLLECT INTO clauses can be specified only in the top query block.
Action: Modify the query.

8094: LEVEL, PRIOR or ROWNUM keywords cannot be used here.
Cause: LEVEL, PRIOR and ROWNUM keywords cannot be used with the PRIOR operator.
Action: Modify the query.

8095: Percentage in a SAMPLE clause must be in the range [0.000001, 100).
Cause: Percentage in a SAMPLE clause must be between 0.000001 and 100 (must be less than 100).
Action: Modify the value to fall within the range.

8096: CONNECT_BY_ROOT operator cannot be used here.
Cause: The CONNECT_BY_ROOT operator cannot be used here.
Action: Modify the query.

8097: CONNECT_BY_ISLEAF operator cannot be used here.
Cause: The CONNECT_BY_ISLEAF operator cannot be used here.
Action: Modify the query.

8098: SYS_CONNECT_BY_PATH operator cannot be used here.
Cause: The SYS_CONNECT_BY_PATH operator cannot be used here.
Action: Modify the query.

8099: CONNECT_BY_ISCYCLE operator cannot be used here.
Cause: The CONNECT_BY_ISCYCLE operator cannot be used here.
Action: Modify the query.

8100: Target must be a table.
Cause: Target of MERGE INTO statement must be a table.
Action: Check the target object.

8101: Column used in the ON clause cannot be updated.
Cause: The column used in an ON clause cannot be updated.
Action: Modify the query.

8102: Outer join cannot be specified for a correlation column.
Cause: An outer join cannot be specified for a correlation column.
Action: Change the query.

8103: Circular synonym detected.
Cause: Synonyms cannot reference themselves.
Action: Check the definition of the synonym.

8104: DECODE function has too many arguments.
Cause: More than 255 arguments were used.
Action: Reduce the number of arguments in the DECODE function.

8105: The CASE function has too many arguments.
Cause: More than 65535 arguments were used.
Action: Reduce the number of arguments in the CASE function.

8106: Outer join operator may not be used in this clause.
Cause: The outer join operator can only be used in ON and WHERE clauses.
Action: Modify the query.

8107: Distributed operation is not supported.
Cause: The MERGE statement attempted to process more than two DB instances.
Action: Modify the query.

8108: Invalid relational operator.
Cause: Invalid condition expression.
Action: Modify the condition expression.

8109: Argument must be a constant expression.
Cause: Only expressions with the same value in GROUP BY clauses are allowed.
Action: Use only expressions which are used in a constant expression or GROUP BY clause.

8110: Too many WHEN clauses used.
Cause: A single multitable insert statement contained more than 127 WHEN clauses.
Action: Reduce the number of WHEN clauses in the statement.

8111: View or remote table cannot be the target of a multitable insert.
Cause: View or remote table cannot be the target of a multitable insert.
Action: Modify the query.

8112: Reference cursor table has too many arguments.
Cause: More than 10,000 arguments were used.
Action: Reduce the number of arguments in the PSM function.

8113: Insufficient arguments specified for a function.
Cause: An argument required for the function was omitted.
Action: Specify the omitted argument again.

8114: Too many arguments specified for a function.
Cause: The number of arguments specified for a function exceeds the number required.
Action: Delete extraneous arguments.

8115: Flashback query clause is not valid here.
Cause: The flashback query clause was used in an invalid location.
Action: Modify the query.

8116: DISTINCT option cannot be used for this function.
Cause: The DISTINCT option cannot be used for this function.
Action: Delete the DISTINCT option and try again.

8117: Invalid datatype used in function.
Cause: The datatype used in the function is invalid.
Action: Check the arguments of the function.

8118: Unable to select rowid column from the index-organized table.
Cause: Unable to select rowid column from the index-organized table.
Action: Remove the rowid column and try again.

8119: Revalidation of trigger ‘%1$s’ failed
Cause: Failed to recompile the invalid trigger.
Action: Modify the trigger source code and create again.

8120: A column ‘%1$s’ for the error log table ‘%2$s’ is missing.
Cause: A column required for the error log table is is missing.
Action: Check the error log table.

8121: Invalid number of arguments.
Cause: The number of arguments is incorrect.
Action: Check the syntax and change it.

8122: Internal hint cannot be used.
Cause: Internal hint cannot be used.
Action: Remove internal hint.

8124: The query defined in the RECURSIVE WITH clause is not valid.
Cause: The query defined in the RECURSIVE WITH clause violates an integrity constraint.
Action: Define the query in the format of (anchor member) UNION ALL (recursive member).

8125: A column alias list was not defined in the RECURSIVE WITH clause.
Cause: Column name aliases were not defined for the query names.
Action: Add a column alias list for the query names in the RECURSIVE WITH clause.

8126: There are statements that are not supported as a recursive member of the recursive WITH clause.
Cause: The following statement cannot be used as a recursive member to the right of UNION ALL statement within the recursive WITH query: GROUP BY, HAVING, DISTINCT, CONNECT BY, window functions, set operations, and aggregate functions.
Action: Rewrite the recursive WITH query so that the unsupported statements are not used.

8127: This join is not supported by the recursive WITH query.
Cause: The recursive WITH clause contains the recursive query name at one of the following positions: the right side of the LEFT OUTER JOIN, the left side of the RIGHT OUTER JOIN, the FULL OUTER JOIN, or in the subquery.
Action: Rewrite the query with the supported join.

8128: Read-only table cannot be updated.
Cause: An attempt was made to execute DML on a read-only table.
Action: Read-only table cannot be updated.

8129: Index by that name was not found.
Cause: Unable to find the index name.
Action: Check the index name and retry.

8130: Index is not partitioned.
Cause: INDEX_PARTITION or INDEX_SUBPARTITION keywords cannot be used in non-partitioned indexes.
Action: Modify the query.

8131: Circular RLS policy has been detected.
Cause: The predicate returned by the policy function refers to the object that the policy is attached to.
Action: Check the definition of the policy function.

8132: The policy predicate contains an error.
Cause: The predicate string generated by the policy function is not valid for this object.
Action: Check the definition of the policy function.

8133: Invalid use of association operator (=>).
Cause: Association operator (=>) can only be used as an UDF argument.
Action: Modify the query.

8134: A user-defined aggregate function can have only one parameter.
Cause: Check the definition or the call of the user-defined aggregate function.
Action: Modify the definition of the user-defined aggregate function and regenerate it.

8135: The ‘%1$s’ interface function is undefined.
Cause: Check the definition of the object type.
Action: Modify the object type definition and regenerate it.

8136: The parameter of the user-defined aggregate function and the parameter of the ‘TUDIAGGREGATEITERATE’ function defined in the object type are not compatible.
Cause: Check the query and the definition of the object type.
Action: Modify the query or the definition of the object type and regenerate it.

8137: The result type of the object type and the result type of the user-defined aggregate function are not compatible.
Cause: Check the query and the definition of the object type.
Action: Modify the query or the definition of the object type and regenerate it.

8138: A single unique index must be specified in the index hint.
Cause: An index was not specified in the IGNORE_ROW_ON_DUPKEY_INDEX hint.
Action: Specify a unique index defined in the table.

8139: Index specified in the index hint is invalid.
Cause: The unique index was not found.
Action: Specify a unique index defined in the table.

8140: Multiple unique indexes were specified in the index hint.
Cause: Multiple unique indexes were specified in the index hint.
Action: Specify a single unique index.

8141: Argument must be a constant expression.
Cause: The specified function argument is invalid.
Action: Check the declaration of the function.

8142: This DML statement is not permitted in the current boot mode.
Cause: In the current boot mode, this DML cannot be executed.
Action: Change the boot mode and run the DML statement again.

8143: Cannot insert a value in a virtual column.
Cause: Attempted to insert a value in a virtual column.
Action: Write insert statements except for this column.

8144: Cannot update a value in a virtual column.
Cause: Attempted to update a value in a virtual column.
Action: Remove the SET clause for this column in UPDATE statements.

8145: The value set to AUTO_INCREMENT COLUMN in the insert statement is incorrect.
Cause: A value other than null cannot be inserted into the AUTO_INCREMENT COLUMN.
Action: Remove AUTO_INCREMENT COLUMN or set the AUTO_INCREMENT COLUMN to null in the insert statement.

8146: A WITH query name has been duplicated in a recursive node in a recursive WITH.
Cause: Self reference can be used only once in a recursive node in a recursive WITH.
Action: Rewrite the query so that a WITH query name can be used only once.

8147: Expressions that return a user-defined type is not allowed in the current context.
Cause: Only expressions that return a built-in type are allowed in the current context.
Action: Check the return type of the expression in the current context.

8148: Expression is not in a SUBQRY LIST clause.
Cause: An expression that was not specified in a SUBQRY LIST clause was used.
Action: Modify the query.

8149: An object table is required.
Cause: This syntax expects an object table.
Action: Check the table specified in the query.

8150: Invalid data type for the split key in the WITH clause.
Cause: The specified type cannot be converted into a string type.
Action: Modify the split key value in the WITH clause.

8151: Expression is not in a SUBQRY LIST clause.
Cause: An expression that was not specified in a SUBQRY LIST clause was used.
Action: Modify the query.

8152: Cannot specify a correlated column.
Cause: A correlated column is not allowed in this context.
Action: Modify the query.

8153: The cursor function was used incorrectly.
Cause: A cursor function must be placed in the outer most select list or used as a psm argument.
Action: Modify the query.

8154: User defined type columns are not permitted.
Cause: User defined type type columns cannot be used.
Action: Modify the query.

8155: Index or partition of such index is in unusable state.
Cause: Index or partition of such index is in unusable state.
Action: DROP the specified index, or REBUILD the specified index.

8156: Logical error in parser.
Cause:
Action:

8157: Data redaction does not support the specified SQL format.
Cause: The query includes operations that are not supported by data redaction.
Action: Modify the query.

8158: Permission denied due to redaction policy.
Cause: The user has insufficient privileges on the redacted table.
Action: Modify the query.

8159: Memory exhausted while parsing the query.
Cause: Memory exhausted while parsing the query.
Action: Increase the memory limit using _PARSE_ALLOWED_MEMORY_DEPTH.

8160: The type of value does not match the type of column.
Cause: The type of value to insert cannot be converted into the type of column.
Action: Check the type of column and value.

8161: Integer value required.
Cause: The input value must be an integer.
Action: Use an integer value expression as the input.

8162: Cannot insert into an always identity column.
Cause: An attempt was made to insert a value into an identity column created with the GENERATED ALWAYS keywords.
Action: A value cannot be inserted directly into an always identity column. The value must be generated by the associated sequence generator.

8163: Cannot update an always identity column.
Cause: An attempt was made to update an identity column created with the GENERATED ALWAYS keywords.
Action: An always identity column cannot be directly updated.

8164: Unable to convert data due to character set mismatch.
Cause: Data conversion between Tibero instances with different character sets is not allowed.
Action: Set both instances to the same character set.

8165: Invalid identifier ‘%1$s’ .
Cause: Unable to interpret the column or identifier.
Action: Check the identifier.

8166: A partition name must be specified for a system partitioned table.
Cause: The partition extended syntax was not used for the system partitioned table.
Action: Use the partition extended syntax to specify the system partitioned table.

8167: The computed column length is too long.
Cause: The column length calculated based on the source and target DB character sets is too long.
Action: Check the target database’s character set and the target column length.

8168: Table does not contain visible columns.
Cause: A query was attempted on a table that does not contain any visible columns.
Action: Retry the operation on a table with a visible column.

8169: Cannot find argument in expressions of PARTITION BY.
Cause: The argument must be in the expressions of the PARTITION BY clause.
Action: Check if the argument exists in the expressions of the PARTITION BY clause.

8170: ‘%1$s’ argument is not function of expressions in PARTITION BY clause.
Cause: The argument must be a function of expressions in PARTITION BY claue.
Action: Check the argument.

8171: COLLECTION columns are not permitted.
Cause: COLLECTION type columns cannot be used.
Action: Modify the query.

8172: Elements in sort specification list of SEARCH clause must be found from the column alias list.
Cause: Cannot find elements in sort specification list of SEARCH clause from the column alias list.
Action: Change the sort specification list to use only names that are listed in the column alias list.

8173: An ordering column name for SEARCH clause must not be part of the column alias list.
Cause: The ordering column name is already in use in the column alias list.
Action: Specify a different name for the ordering column or change the name in the column alias list.

8174: Elements in cycle column list of CYCLE clause must be found from the column alias list.
Cause: Cannot find elements in cycle column list of CYCLE clause from the column alias list.
Action: Change the cycle column list to use only names that are listed in the column alias list.

8175: A cycle mark column name for CYCLE clause must not be part of the column alias list.
Cause: The cycle mark column name is already in use in the column alias list.
Action: Specify a different name for the cycle mark column or change the name in the column alias list.

8176: The ordering column for SEARCH clause must be different from the cycle mark column for CYCLE clause.
Cause: The ordering column for SEARCH clause matches the cycle mark column for CYCLE clause.
Action: Change either the ordering column or the cycle mark column so that they no longer match.

8177: The cycle value for CYCLE clause must be different from the non-cycle value.
Cause: The cycle value for CYCLE clause is the same as the non-cycle value.
Action: Change either the cycle or the non-cycle values so that they no longer match.

8178: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements.
Cause: A SEARCH or CYCLE clause is specified for a non-recursive WITH clause element.
Action: Remove the SEARCH or CYCLE clause, or add recursion to the WITH clause element.

8179: MAXVALUE partition cannot be specified for Interval partitioned objects.
Cause: An attempt was made to create a partition with a MAXVALUE highbound on an Interval partitioned object.
Action: Do not create a partition with a MAXVALUE highbound.

8180: Interval expression is not a constant of the correct type.
Cause: You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column.
Action: Use only constant expressions for the interval. If the data type of partitioning column is numeric, the interval must be a numeric constant. If the data type is of type date/time, the interval must be a constant of interval type.

8181: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE.
Cause: Partition bound list contained an element of invalid type (i.e. not a number, non-empty string, datetime or interval literal, or MAXVALUE).
Action: Ensure that all elements of partition bound list are of valid type.

8182: The number of variables in the tuple exceeds the maximum allowed count.
Cause: The tuple cannot contain more variables than the maximum count.
Action: Modify the query and ensure that the tuple contains fewer variables than the maximum count, or specify the iparam (_PARAM_CNT_LIMIT_IN_TUPLE) value to adjust the maximum count for the tuple.

8183: JSON columns are not permitted.
Cause: JSON type columns cannot be used.
Action: Modify the query.

8184: ORDER SIBLINGS BY clause not allowed here.
Cause: ORDER SIBLINGS BY clause cannot be used with the PRIOR operator.
Action: Modify the query.

---

Tibero Error Message 9000~9999

9001: File ‘%1$s’ was not found.
Cause: The file does not exist.
Action: Check if the file exists or use another file.

9002: Input file was not specified.
Cause: An input file was not specified.
Action: Specify an input file.

9003: Multiple input files were specified.
Cause: Two or more input files were specified.
Action: Specify only one input file.

9004: Unable to open file ‘%1$s’.
Cause: Cannot open the output file.
Action: Verify that the file name is correct.

9005: Unable to locate configuration file ‘%1$s’.
Cause: The configuration file could not be found.
Action: Verify that the path to the configuration file is correct.

9006: Unrecognized file format.
Cause: Invalid file extension.
Action: The input file name must have an extension.

9007: File name is too long.
Cause: The input file name is over 256 bytes long.
Action: Reduce the length of the file name.

9008: Cursor ‘%1$s’ is undefined.
Cause: Undefined cursor name.
Action: Verify that the cursor name is correct.

9009: Database ‘%1$s’ is undefined.
Cause: Undefined DB name.
Action: Verify that the DB name is correct.

9010: Invalid DML statement.
Cause: The DML statement syntax is incorrect.
Action: Verify that the syntax of the DML statement is correct.

9011: Invalid dynamic SQL syntax.
Cause: The dynamic SQL statement is invalid for the ANSI mode.
Action: Use a dynamic SQL statement that is valid for the ANSI mode.

9012: CONTEXT USE statement was not found.
Cause: A CONTEXT USE statement was not used to specify context application.
Action: Use a CONTEXT USE statement.

9013: THREADS option is not enabled.
Cause: To use a thread-related command, the THREADS option needs to be set to YES.
Action: Set the THREADS option to YES.

9014: Context not allocated.
Cause: The context is not allocated.
Action: Allocate the context.

9015: Invalid parameter expression ‘%1$s’.
Cause: The parameter expression is invalid.
Action: Check the expression syntax.

9016: Host variable ‘%1$s’ must be declared in the declare section.
Cause: The host variable is not declared in the declare section.
Action: In ANSI or ISO mode, only variables declared between the EXEC be used as a host variable.

9017: Array size of host variable ‘%1$s’ is out of range.
Cause: The array size of the host variable is invalid.
Action: Modify the array size of the host variable so that it is an integer greater than 1.

9018: Undeclared identifier ‘%1$s’.
Cause: The identifier is not defined.
Action: Define the identifier.

9019: Undefined structure ‘%1$s’.
Cause: The structure is not defined.
Action: Define the structure.

9020: Undefined type ‘%1$s’.
Cause: The type is not defined.
Action: Define the type.

9021: ‘%1$s’ is not defined as a struct.
Cause: Only objects defined as structures may be used in that manner.
Action: Use an object that is defined as a structure.

9022: Invalid indirection object ‘%1$s’.
Cause: Accessed a pointer with a period (.), or accessed non-pointer with an arrow (->).
Action: Review the item and use the correct access method.

9023: ‘%1$s’ is not a member of structure ‘%2$s’.
Cause: Undefined member of a structure.
Action: Define the object as a member of the structure.

9024: Parameter ‘%1$s’ cannot be multi-dimensional.
Cause: An attempt was made to bind a multi-dimensional array type.
Action: Modify the bind parameter.

9025: Arrays of structs must be named.
Cause: No name is defined for the host structure declared as array.
Action: Specify a name for the structure.

9026: Structure variable ‘%1$s’ has a nested structure.
Cause: A structure cannot be bound in another structure.
Action: Delete the nested structure definition.

9027: Structure ‘%1$s’ cannot have members that are arrays.
Cause: An array cannot be a member of the structure.
Action: Remove the array from the members of the structure.

9028: Invalid VARCHAR format: must be a 1 or 2 dimensional array.
Cause: The format of VARCHAR is invalid.
Action: If VARCHAR is an invalid array, modify it and re-declare it.

9029: Cursor ‘%1$s’ is already defined.
Cause: The cursor name is already defined.
Action: Use another cursor name.

9030: Database ‘%1$s’ is already defined.
Cause: The DB name is already defined.
Action: Use another DB name.

9031: Prepared statement ‘%1$s’ was not found.
Cause: No SQL statement is prepared yet.
Action: Prepare an SQL statement.

9033: Indicator variable ‘%1$s’ must be a SHORT type.
Cause: The indicator variable is not a SHORT type.
Action: Declare the indicator variable as a SHORT type.

9034: Indicator variable ‘%1$s’ for host variable ‘%2$s’ cannot be a structure.
Cause: The indicator variable cannot be a structure because the host variable is not a structure.
Action: Match the type of host variable to the type of indicator variable.

9035: Indicator variable ‘%1$s’ must be a structure.
Cause: The indicator variable must be a structure because the host variable is a structure.
Action: The indicator variable must be defined as a structure.

9036: Indicator variable ‘%1$s’ must have the same dimensions as the param variable
Cause: The host variable has different dimensions as the indicator variable.
Action: The indicator variable must have the same dimensions as the host variable.

9037: Invalid use of signed or unsigned operator.
Cause: Invalid signed or unsigned operator has been used to defined variables.
Action: Delete signed or unsigned operator.

9038: Invalid type declared.
Cause: Invalid type declared.
Action: Check if a structure or typedef definition is used with a primitive type.

9039: Two or more data types are in declaration.
Cause: Invalid type declaration.
Action: Check if the declaration of structure or typedef is duplicated.

9040: Duplicate signed or unsigned operators exist.
Cause: More than one signed or unsigned operator.
Action: Correctly mark signed or unsigned.

9041: Array value ‘%1$s’ is not allowed in WHERE clauses of a SELECT statement.
Cause: Array variables cannot be used in WHERE clauses of a SELECT statement.
Action: Change array variables in WHERE clauses of the SELECT statement into general variables.

9042: When updating, if any host variable is an array type, all host variables must be.
Cause: When updating, if at least one of host variables is an array type, all host variables should be array type, and vice versa.
Action: Declare all host variables as array.

9043: Table was not found.
Cause: The table does not exist or is not declared in any clause.
Action: Declare the table.

9044: Invalid column name(s).
Cause: The column(s) could not be found.
Action: Check the name of the column(s).

9045: Invalid DML syntax %1$s.
Cause: Invalid DML syntax.
Action: Verify that the DML syntax is correct.

9046: Invalid ESQL syntax %1$s.
Cause: Invalid ESQL syntax .
Action: Verify that the ESQL syntax is correct.

9047: Invalid C syntax.
Cause: Invalid C syntax.
Action: Verify that the C syntax is correct.

9048: Failure while preprocessing %1$s.
Cause: Failed to preprocess C programming language.
Action: Locate the cause of the error and modify it.

9049: Unexpected identifier %1$s.
Cause: The SQL statement starts with a string that is not an ESQL directive.
Action: Verify that the ESQL syntax is correct.

9050: Invalid use of AT clause.
Cause: The syntax should not contain an AT clause.
Action: Delete the AT clause.

9051: Host variable type is not compatible with column type.
Cause: The host variable type is not compatible with the column type of the table.
Action: Check the type of host variable.

9052: Parameter count does not match column count.
Cause: The number of parameters is different from the number of columns.
Action: Check the number of parameters.

9053: Semantics check failed at server.
Cause: Failed to check semantics using server.
Action: Verify that the semantics are correct.

9054: Invalid option.
Cause: Unsupported option.
Action: Delete the option.

9055: Option ‘%1$s’ cannot be used here.
Cause: The option cannot be used here.
Action: Check the location (config file, command line, etc.) where location.

9056: Option value type ‘%1$s’ is invalid.
Cause: Invalid type of option value.
Action: Check the type of the option value.

9057: Option value ‘%1$s’ of %2$s is invalid.
Cause: Invalid option value.
Action: Check the option value.

9058: Option ‘%1$s’ was not found.
Cause: Undefined option.
Action: Verify that the option exists.

9059: Incomplete multiple option value.
Cause: Invalid format of the option value.
Action: Check the format of the option value.

9060: USERID option should be specified when SQLCHECK=SEMANTICS or FULL.
Cause: If SQLCHECK=SEMANTICS (or FULL), USERID should be also specified.
Action: Specify the USERID option.

9061: User ID ‘%1$s’ is too long.
Cause: User ID must be less than 128 bytes.
Action: Reduce the size of the user ID.

9062: Password is too long.
Cause: Password must be less than 63 bytes.
Action: Reduce the size of the password.

9063: SQLCHECK=SEMANTICS must be specified when embedded PSM blocks are used.
Cause: Embedded PSM block was used without the SQLCHECK=SEMANTICS option.
Action: Specify the SQLCHECK=SEMANTICS option.

9064: Unable to connect to server.
Cause: Failed to access the server for semantics check.
Action: Check the connection information and server status.

9067: Improperly terminated C comment.
Cause: A C comment beginning with ‘/*’ was not terminated.
Action: Terminate the comment properly.

9068: Improperly terminated UNION.
Cause: UNION is not properly terminated.
Action: Check the syntax.

9069: C preprocessing failed.
Cause: Failure while preprocessing C programming language.
Action: Correct the error as shown in the additional messages.

9071: Not logged into the server.
Cause: Not properly connected to the server.
Action: Connect to the server and retry.

9074: Host variable address is NULL.
Cause: The address of the host variable is NULL.
Action: Specify a valid host variable.

9075: Cursor was not found.
Cause: The cursor to be used is not declared.
Action: Declare the cursor first.

9076: In ANSI mode, already-closed cursors may not be closed again.
Cause: Closed cursors cannot be closed again in ANSI mode.
Action: Make sure that the specified cursor isn’t already closed.

9077: In ANSI mode, already-opened cursors may not be opened again.
Cause: Opened cursors cannot be opened again in ANSI mode.
Action: Make sure that the specified cursor isn’t already open.

9078: Invalid parameter type.
Cause: Invalid parameter type.
Action: Verify that the parameter type is correct.

9079: Invalid connection string.
Cause: Invalid connection string.
Action: Verify that the connection string is correct.

9080: Invalid use of output parameter.
Cause: Invalid use of output parameter.
Action: Check the output parameter.

9081: Invalid use of input parameter.
Cause: Invalid use of input parameter.
Action: Check the input parameter.

9082: Unspecified cursor name.
Cause: A cursor name was not specified.
Action: Specify the cursor name.

9083: Unspecified prepared statement name.
Cause: The prepared statement name is unspecified.
Action: Specify the name of the prepared statement.

9084: Unspecified database name.
Cause: The database name is unspecified.
Action: Specify the name of the database.

9085: Invalid database name
Cause: The length of database name is 0.
Action: Specify a DB name.

9086: Undefined prepared statement name.
Cause: The prepared statement that was used is not defined..
Action: Verify that the name of the prepared statement is correct.

9087: Input descriptor has not been described.
Cause: Describe input for descriptor has not been performed.
Action: Perform describe input first.

9088: Undefined SQLDA variable.
Cause: The SQLDA variable that was used is not defined.
Action: Define the SQLDA variable first.

9089: No connection to database.
Cause: The connection opened with the database name does not exist.
Action: Make a connection first.

9090: Database connection is closed.
Cause: The specified database connection is closed.
Action: Try to reconnect.

9091: Cursor operation on wrong database.
Cause: This cursor is not defined for the specified database.
Action: Specify the correct database name.

9092: Number of output parameters does not match number of output columns.
Cause: The number of output parameters does not match the number of output columns.
Action: Ensure that the quantities match.

9093: Number of bind variables does not match number of parameters.
Cause: The number of bind variables does not match the number of parameters.
Action: Ensure that the quantities match.

9094: Indicator variable was not specified in INTO clause.
Cause: The indicator variable was not specified in the INTO clause.
Action: Specify the indicator variable for the INTO clause.

9095: Too many rows were returned by SELECT statement.
Cause: Too many rows were returned by a select statement.
Action: Ensure that the expected number of rows does not violate any constraints.

9096: Charmap failed.
Cause: The result does not match the given charmap.
Action: Make sure the result value is not null or an invalid value.

9097: Fetch out of sequence.
Cause: The statement has been executed in wrong sequence.
Action: Execute ESQL statements according to the fetch execution sequence.

9098: Duplicate descriptor name exists.
Cause: The descriptor name already exists.
Action: Use another name for the descriptor.

9099: Unknown descriptor.
Cause: The descriptor has not been assigned.
Action: Assign the descriptor first.

9100: Undefined descriptor name.
Cause: An attempt was made to use an undefined descriptor.
Action: Verify that the name of the descriptor is correct.

9102: Host structure ‘%1$s’ cannot be used in embedded PSM or dynamic SQL.
Cause: An attempt was made to use a host structure for embedded PSM or dynamic SQL.
Action: Use a general variable type, not a structure.

9103: Include file ‘%1$s’ does not exist.
Cause: The file to be included does not exist.
Action: Specify a valid file path with the INCLUDE option.

9104: Option ‘%1$s’ cannot be used for this host language.
Cause: This option cannot be used for this host language.
Action: Check the locations where this option can be used (config file, command line, etc.).

9105: Invalid COBOL syntax.
Cause: Invalid COBOL syntax.
Action: Verify that the COBOL syntax is correct.

9106: Preprocessing failed at line %1$d because of %2$s.
Cause: Preprocessing of COBOL language failed.
Action: Locate the cause of the failure and fix it.

9107: Invalid argument ‘%1$s’.
Cause: Invalid argument.
Action: Check the help file for the Precompile utility.

9108: Invalid include filen%1$s.
Cause: An invalid header file has been included.
Action: Verify that the header file is correct.

9109: Reserve word ‘defined’ cannot be used as macro name.
Cause: An attempt was made to use ‘defined’ as a macro name.
Action: Change the macro name.

9110: Macro name not specified in #%1$s directive.
Cause: A macro name was not specified in #%1$s directive.
Action: Modify the macro.

9111: Invalid macro name.
Cause: The macro name is inappropriate.
Action: Modify the macro to follow the syntax of C programming language.

9112: Invalid #%1$s syntax.
Cause: #%1$s syntax is invalid.
Action: Use #%1$s “file name” or #%1$s .

9113: Recursive #include file.
Cause: The #include file is recursive.
Action: Check the #include files and fix the recursion problem.

9114: Invalid #%1$s directive.
Cause: The #%1$s directive is invalid.
Action: Modify the #%1$s directive.

9115: Invalid #pragma GCC poison directive.
Cause: The #pragma GCC poison directive is invalid.
Action: Modify the #pragma GCC poison directive.

9116: Invalid pragma.
Cause: The pragma is invalid.
Action: Modify the pragma syntax.

9117: Invalid conditional syntax (if-else-endif).
Cause: The syntax of the conditional clause (IF-ELSE-ENDIF) is invalid.
Action: Correct the clause syntax.

9118: Non-terminated #%1$s directive.
Cause: The #%1$s directive is non-terminated.
Action: Fix the directive syntax.

9119: Invalid predicate syntax in #assert and #unassert.
Cause: Predicate syntax used in #assert and #unassert is invalid.
Action: Modify the syntax.

9120: Unable to paste %1$s and %2$s because they generate an invalid preprocessing token.
Cause: Cannot paste the two specified tokens together.
Action: Modify the setting syntax.

9121: Too many arguments specified for ‘%1$s’ macro: %2$u arguments accepted, %3$u arguments specified.
Cause: The ‘%1$s’ macro accepts %2$u arguments, but %3$u arguments were specified.
Action: Modify the clause with the ‘%1$s’ macro.

9122: Arguments specified for ‘%1$s’ macro are not terminated.
Cause: One or more arguments of the ‘%1$s’ macro are not terminated.
Action: Modify the setting syntax.

9123: Duplicate parameter ‘%1$s’ exists in macro.
Cause: The ‘%1$s’ parameter of the macro is specified twice.
Action: Delete one of the duplicate parameters.

9124: Unknown ‘%1$s’ parameter in macro.
Cause: ‘%1$s’ is not in the macro parameter list.
Action: Verify that the parameter name is correct.

9125: Invalid macro parameter syntax.
Cause: Macro parameter syntax is invalid.
Action: Correct the macro parameter syntax.

9126: The # token is not in macro parameter list.
Cause: # token is not in the macro parameter list.
Action: Modify the setting syntax.

9127: Invalid syntax near ‘##’ operator.
Cause: The syntax of the part using the ‘##’ operator is bad.
Action: Modify the setting to meet the syntax.

9128: Conditional expression contains a division by zero error.
Cause: The conditional expression contains division by 0 error.
Action: Modify the conditional expression.

9129: Invalid syntax when using the ‘defined’ operator.
Cause: The ‘defined’ operator uses invalid syntax.
Action: Modify the syntax used with the operator.

9130: Unable to open the ‘%1$s’ file.
Cause: Unable to open the ‘%1$s’ file.
Action: Specify a valid file path.

9131: Invalid size of VARCHAR ‘%1$s’.
Cause: The length of the given VARCHAR is invalid.
Action: Change the length of the VARCHAR.

9132: Invalid use of REF clause.
Cause: A REF clause may not be used here.
Action: Delete the invalid REF clause.

9133: Copy/include file ‘%1$s’ in line %2$d was not found.
Cause: No file to copy or include.
Action: Specify a valid file to copy or include with the INCLUDE option.

9134: Invalid line continuation.
Cause: The continued line does not follow COBOL programming language syntax.
Action: Locate out the cause of the error and fix it.

9135: Host variable ‘%1$s’ is of an invalid type.
Cause: This type of host variable is not supported.
Action: Find out the cause of the failure, and modify the part having the problem in the message.

9136: Indicator variable ‘%1$s’ must be int type because of IND_TYPE option
Cause: Indicator variable must be int type because IND_TYPE is 32bit.
Action: Declare indicator variable as int type.

9137: Unhandled character ‘%1$s’.
Cause: Invalid character.
Action: Check that the character is placed in the correct location.

9138: Invalid host variable ‘%1$s’.
Cause: Invalid host variable.
Action: Check that the variable is placed in the correct location.

9139: Missing trailing NULL character.
Cause: A host variable of external data type 5 was not terminated with a NULL character.
Action: Add NULL to the end of the character string.

9140: Invalid iteration count.
Cause: Invalid iteration count.
Action: Iteration count must contain an integer value of 1 or greater.

9141: Invalid parameter data length (dynamic method 4)
Cause: Invalid parameter data length (dynamic method 4)
Action: Set the variable length to a correct value.

9142: Semantics check failed during the communication process.
Cause: Failed to check semantics with the server due to communication problems.
Action: Check the communication status with server.

9143: Execute ‘client/config/gen_esql_cfg.sh’ from the database home directory.
Cause: ESQL configuration has not yet been performed.
Action: Execute the ‘gen_esql_cfg.sh’ file from the ‘client/config’ directory under the database home directory.

9144: Invalid ‘EXEC SQL INCLUDE’ statement.
Cause: Invalid EXEC SQL INCLUDE statement.
Action: Modify the syntax of the EXEC SQL INCLUDE statement.

9145: Invalid parameter data type (dynamic method 4)
Cause: Invalid parameter data type (dynamic method 4)
Action: Check whether the variable type is valid.

9146: Invalid parameter data type (ANSI dynamic method 4)
Cause: Invalid type of bind variable (ANSI type dynamic SQL method 4).
Action: Verify that the bind variable type is valid.

9147: Expression was previously declared with a specific database connection.
Cause: The expression used in PREPARE was previously declared to use a particular database connection.
Action: Do not use an AT clause, or modify the DECLARE clause.

9148: Unable to use ESQL statement in ordinary C include file.
Cause: An ESQL statement is used in an included header file.
Action: To use an ESQL statement, use an EXEC SQL INCLUDE statement.

9150: Unable to open directory ‘%1$s’: Permission denied.
Cause: Not authorized to access this directory.
Action: Receive authorization to open the directory.

9151: ‘%1$s’ is not a directory.
Cause: The path after #include does not specify a valid directory.
Action: Specify a valid directory.

9152: Precision or scale is out of range.
Cause: The precision or scale of the declared type is out of range.
Action: Check the precision or scale, and enter a value that is within range.

9153: Dynamic SQL is not DML.
Cause: The SQL is not DML.
Action: Check the SQL.

9154: Dynamic SQL is DDL.
Cause: The SQL is DDL.
Action: Check the SQL.

9155: Dynamic SQL is PSM.
Cause: The SQL is PSM.
Action: Check the SQL.

9156: The size of esql log file is wrong.
Cause: The size of log file is too large or too small.
Action: Check the esql config file, enter a value that is within the range(>= 1M and <= 1G).

9157: The length in the host variable is wrong.
Cause: The lengths in the host variable and in the length field do not match.
Action: Check the code and fix the length field of SQLDA or the length in the host variable(VARCHAR or other type).

9158: The number of bind variables does not match the number of attributes.
Cause: The number of bind variables does not match the number of attributes.
Action: Check the numbers of bind variables and attributes.

9159: Unable to create output file ‘%1$s’.
Cause: Output file name is same with Input file name.
Action: Verify that the output file name is different from input file name.

9160: Multiple output files were specified.
Cause: Two or more output files were specified.
Action: Specify only one output file.

9161: Ambiguous variable ‘%1$s’ is referenced.
Cause: Ambiguous variable ‘%1$s’ is referenced.
Action: Check the host variable.

9162: Database name is too long.
Cause: Database name must be less than 128 bytes.
Action: Reduce the size of the database name.

9163: Invalid dynamic SQL method-2.
Cause: The dynamic SQL statement must not be a query (SELECT statement).
Action: Use a dynamic SQL method 3, 4 or modify the dynamic SQL.

9164: Struct Indicator member count does not match struct host variable member count.
Cause: The number of struct indicator members is different from the number of struct host variable members.
Action: Check the number of struct indicator members.

9165: Invalid PL/1 syntax.
Cause: Invalid PL/1 syntax.
Action: Verify that the PL/1 syntax is correct.

9166: Database was not installed successfully.
Cause: Database was not installed successfully.
Action: Execute the install batch file in the bin directory of the Database Home.

9167: Not yet implemented.
Cause: This function has yet to be implemented.
Action: This function has yet to be implemented.

9168: Failed to free CLI ENVIRONMENT HANDLE.
Cause: Failed to free CLI ENVIRONMENT HANDLE while deleting esql context manager
Action: Check the statements related to ENVIRONMENT HANDLE.

9169: Not yet Implemented
Cause: This feature is currently not available.
Action: Please go around the problem or contact the manufacturer.

9170: Error code from Oracle
Cause: Error has occured while interacting with Oracle binary.
Action: Please check error code(sqlca.oracode) from Oracle’s error utility.

9171: Failed to return CLI HANDLE.
Cause: Unable to find expected CLI HANDLE.
Action: Check the status of the connection or the parameters for ESQLGetHandle().

9172: ODBC connection is closed or failed to connect.
Cause: ODBC connection is closed or failed to connect.
Action: Check the status of the connection or ID/PASSWD.

9173: Invalid COBOL syntax ‘%1$s’.
Cause: Invalid COBOL syntax.
Action: Verify that the COBOL syntax is correct.

9174: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
Cause: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
Action: Check the cursor statement whether FOR UPDATE clause is defined or not

9175: ODBC general error
Cause: General error(HY000) caused by ODBC
Action: Check the error message on application

---

Tibero Error Message 10000~10999

10001: Cursor pool overflow.
Cause: The cursor pool is full.
Action: Increase the size of the pool.

10003: Data is too long to be bound to the specified type.
Cause: The amount of data exceeds the maximum allowed of the type to which it will be bound.
Action: Modify the length of the data.

10004: Cannot use UNION command on these tables or views.
Cause: Cannot perform the UNION operation for the given tables or views.
Action: Check that the numbers of columns are equal and that the types of each column are compatible.

10005: NOT NULL constraint violation (‘%1$s’.’%2$s’.’%3$s’).
Cause: An attempt was made to insert the NULL value into a column where the NOT NULL constraint is specified.
Action: Remove the NOT NULL constraint, or insert a value that is not NULL.

10006: CHECK constraint violation (‘%1$s’.’%2$s’).
Cause: The inserted value(s) do(es) not satisfy the existing CHECK condition.
Action: Insert a value that satisfies the CHECK condition.

10007: UNIQUE constraint violation (‘%1$s’.’%2$s’).
Cause: An attempt was made to insert a duplicate value into a column where the UNIQUE constraint is specified.
Action: Cancel the UNIQUE constraint, or insert a unique value.

10008: INTEGRITY constraint violation (‘%1$s’.’%2$s’): primary key not found.
Cause: A primary key does not exist for the foreign key.
Action: Delete the foreign key, or add a primary key.

10009: INTEGRITY constraint violation (‘%1$s’.’%2$s’): foreign key exists.
Cause: An attempt was made to delete a primary key that is referenced by a foreign key.
Action: Delete the foreign key first and then try again.

10010: Statement does not satisfy the WHERE clause of the view.
Cause: The INSERT or UPDATE statement of the view does not satisfy the WHERE clause when the WITH CHECK OPTION is specified.
Action: Modify the DML statement to satisfy the WHERE condition clause of the view, or delete WITH CHECK OPTION of the view.

10011: SORT_AREA_SIZE is too small to accommodate all active sort operators.
Cause: There are not enough allocated sort areas.
Action: Increase the value of SORT_AREA_SIZE.

10012: Cannot pin more blocks.
Cause: Cannot process all data because the buffer cache is not big enough.
Action: Increase the value of DB_CACHE_SIZE.

10013: HASH_AREA_SIZE is too small to accommodate all active sort operators.
Cause: There are not enough allocated hash areas.
Action: Increase the value of HASH_AREA_SIZE.

10014: Maximum LEVEL value exceeded during a CONNECT BY operation.
Cause: The LEVEL value of a node exceeded the maximum during a CONNECT BY operation.
Action: Contact the technical support team.

10015: Loop detected during a CONNECT BY operation.
Cause: A loop was detected during a CONNECT BY operation.
Action: Modify the CONNECT BY clause and data so that a loop does not occur.

10016: Table mutation occurred during trigger execution.
Cause: Table mutation occurred during trigger execution.
Action: Delete the mutation.

10017: Unable to open file ‘%1$s’ in file scan mode.
Cause: The specified file could not be found.
Action: Check the name and directory of the specified datafile.

10018: Partition key does not map to a partition.
Cause: There is no defined partition to which the partition key is mapped.
Action: Check the definition of the partition in the corresponding table.

10019: Updating partition key column would cause a partition change.
Cause: Updating the partitioned table key will cause a partition change.
Action: Check the definition of the partition in the corresponding table.

10020: Specified row no longer exists.
Cause: The specified row does not exist.
Action: Verify that the specified row is correct.

10021: Inconsistent set of rows in source tables.
Cause: Inconsistent DML result due to a non-deterministic WHERE condition.
Action: Modify the non-deterministic WHERE condition.

10022: Empty pivot column must not exist.
Cause: There is an empty pivot column.
Action: Modify the PIVOT_PICK_COL parameter.

10023: Invalid pivot aggregation alias.
Cause: An error occurred in the string pattern that determines a column name when performing a pivot operation.
Action: Check to see if a percent (%) character is missing in the string pattern.

10024: Pivot column name must be unique for CASE or DECODE operations.
Cause: Results with the same pivot column name were selected when performing a CASE/DECODE operation.
Action: Modify the string pattern for the column names given to each set operation when performing a pivot operation.

10025: Too many pivot column names generated after calculation.
Cause: There are too many pivot column names created after calculation.
Action: Decrease the number of calculations.

10026: The REFCUR table contains invalid number of columns.
Cause: The number of columns defined in the REFCUR table does not match the actual number.
Action: Modify the REFCUR table clause to match the actual number.

10027: REFCUR table contains invalid column type.
Cause: The data type of a column defined in the REFCUR table does not match the actual data type.
Action: Modify the REFCUR table clause to match the actual data type.

10028: Number of columns specified in file ‘%1$s’ and in data dictionary do not match.
Cause: The number of columns specified in the file does not match the number of columns in the data dictionary.
Action: Check the number of columns of specified in the file.

10029: Unable to read table (or index) with old snapshot.
Cause: Unable to read a table or index with an old snapshot.
Action: Use a snapshot from after the table or index was modified.

10030: Invalid WKB geometry data.
Cause: The entered WKB data is invalid.
Action: Check the WKB data.

10031: Invalid geometric object type.
Cause: An invalid geometric object type was executed.
Action: Check to see if the geometric object type is executable.

10032: Index number is out of range.
Cause: The value of N is less than 1 or larger than the number of Points in LineString.
Action: Check the N value.

10033: Invalid WKT geometry data.
Cause: The entered WKT data is invalid.
Action: Check the WKT data.

10034: Internal error: %1$s.
Cause: An internal error occurred.
Action: Check the data.

10035: Invalid pivot expression.
Cause: Too many pivot columns were created after the operation.
Action: Check the query.

10036: Invalid XML.
Cause: An invalid type of XML was entered.
Action: Check the XML.

10037: Invalid XQuery.
Cause: Invalid XQuery.
Action: Check the XQuery syntax.

10038: Comparing multi-valued pivot columns is restricted.
Cause: Comparing multi-valued pivot columns is restricted.
Action: Check whether the pivot columns have multi values.

10039: Invalid text query syntax.
Cause: Invalid query syntax of the text.
Action: Check the query syntax.

10040: No more stop words can be inserted.
Cause: Cannot add another stop word for the text.
Action: Check the number of stop words.

10041: The text index is invalid.
Cause: The text index is not available.
Action: Check the text index status.

10042: A multi valued result is not allowed.
Cause: Multi valued results are not allowed.
Action: There are multiple results for XPath in the XML.

10043: Invalid XPath expression.
Cause: Invalid XPath expression.
Action: Check the XPath expression.

10044: Invalid child value.
Cause: Invalid child value.
Action: Check the child value.

10046: XML library error ‘%1$s’.
Cause: An error occurred in an external XML library.
Action: Check the error message.

10047: XQuery type mismatch.
Cause: The return type of XQuery does not match the declared column type.
Action: Change the type of the column.

10048: XPath does not point to a leaf node.
Cause: The given XPath does not indicate a leaf node.
Action: Modify XPath to indicate a leaf node.

10049: XPath does not point to a single node.
Cause: The given XPath has multiple nodes.
Action: Modify XPath to have only one node.

10050: Size of datatype is too small to serialize the XML document.
Cause: The size of the data type to serialize the XML document is too small.
Action: Increase the data type size.

10051: Invalid XML namespace.
Cause: The format of the XML namespace is invalid.
Action: Check whether the format is ‘xmlns:=’.

10052: The XML document is too big for the DOM tree.
Cause: The XML document is too big for the DOM tree.
Action: Decrease the size of the XML document.

10053: It is impossible to bind two or more LOBs or LONG data together.
Cause: It was attempted to bind two or more LOBs or LONG data through the remote database.
Action: Check the SQL and change it.

10054: The table needs more tablets.
Cause: Add tablets to the table
Action:

10055: The table needs more tablets for bucketno ‘%1$d’.
Cause: Add ‘%1$d’ bucketno tablets to table.
Action:

10062: Unable to access LONG or LOB columns through RemoteDB.
Cause: An attempt was made use RemoteDB to refer to an object with LONG or LOB columns.
Action: Modify the query.

10063: The cached remote table information does not match the actual remote table’s information.
Cause: The remote table definition (number of columns, type, or length) has changed.
Action: Try again.

10064: Loop detected during %1$s operation.
Cause: A loop was detected during a %1$s operation.
Action: Modify the %1$s clause or data so that a loop does not occur.

10065: There are too many Aggregate functions.
Cause: Cannot be executed in parallel or in multiple passes.
Action: Cannot be executed in parallel or in multiple passes.

10066: Invalid TSN value.
Cause: The TSN value of the flashback query must be greater than 0.
Action: Use a valid TSN value.

10067: The policy check constraint is violated.
Cause: The data to be added or updated does not satisfy the policy predicate.
Action: None

10068: The number of columns in the cached remote table does not match the number of columns in the remote table. (local: %1$d, remote: %2$d)
Cause: The number of columns in the remote table has changed, or the number of columns in the REFCUR/PROC table has been incorrectly set.
Action: Retry or modify the number of columns in the REFCUR/PROC table.

10069: The column length of the cached remote table is shorter than the column length of the remote table. (column: %1$d, local: %2$d bytes, remote: %3$d bytes)
Cause: The column length of the remote table has changed, or the column length of the RERCUR/PROC table has been incorrectly set.
Action: Retry or modify the column length of the REFCUR/PROC table so that it is longer than or the same as the column length of the remote table.

10070: The column type of the cached remote table does not match the column type of the remote table. (column: %1$d, local: %2$s, remote: %3$s)
Cause: The column type of the remote table has changed, or the column type of the REFCUR/PROC table has been incorrectly set.
Action: Retry or modify the column type in the REFCUR/PROC table.

10071: Cannot assign a process to execute the global view.
Cause: All processes are currently in use.
Action: Increase the number of processes or terminate another session.

10072: Cannot assign a thread to execute the global view.
Cause: All threads are currently in use.
Action: Increase the number of threads or terminate another session.

10073: Response time for the global view exceeded threshold.
Cause: Global view search is taking a long time or there is a network problem.
Action: Increase the response time limit for the global view.

10074: An error occurred while executing the ‘%1$s’ function.
Cause: Check the definition of the object type.
Action: Modify the definition of the object type and regenerate it.

10075: Exceeds the reject limit.
Cause: Exceeds the reject limit.
Action: Modify the data or increase the reject limit.

10076: Received a GV error reply(ec=%1$d) from session %2$d.
Cause: One of GV sessions sent an error reply.
Action: Check the error of the error-occurred session in the log file.

10077: The pattern used with the LIKE operator is too long.
Cause: The pattern used with the LIKE operator is too long.
Action: Check the pattern used with the LIKE operator.

10078: Partial multibyte character found.
Cause: Character set conversion did not occur due to partial multibyte character or buffer overflow.
Action: Check the data.

10079: catsearch does not support functional invocation.
Cause: catsearch does not support functional invocation.
Action: Check the catsearch syntax.

10080: DML rolled back due to index integrity.
Cause: The current DML was rolled back because it caused index integrity violation.
Action: Check the tracedump.

10081: Communication between Tibero and storage server failed.
Cause: Communication between Tibero and storage server failed.
Action: Check the information of storage server.

10082: This function is not supported in current envrionment.
Cause: Contact the technical support team.
Action:

10083: Cannot assign a process to execute the in-memory column store.
Cause: All processes are currently in use.
Action: Increase the number of processes or terminate another session.

10084: Cannot assign a thread to execute the in-memory column store.
Cause: All threads are currently in use.
Action: Increase the number of threads or terminate another session.

10085: Response time for the in-memory column store exceeded threshold.
Cause: In-memory column store scan is taking a long time or there is a network problem.
Action: Increase the response time limit for the in-memory column store scan.

10086: Received an in-memory column store error reply(ec=%1$d) from session %2$d.
Cause: One of in-memory column store sessions sent an error reply.
Action: Check the error of the error-occurred session in the log file.

10087: The status of a remote node has been changed while executing in-memory cloumn store scan.
Cause: The status of a remote node has been changed.
Action: Check the status of the remote node and execute the SQL statement again.

10088: Invalid token length (Allowable length: 1 to 64 bytes, current length: %1$d bytes)
Cause: An invalid token length was encountered while generating a text index.
Action: Check the column to be indexed.

10089: The value for argument number %1$d is not valid.
Cause: The value entered as the function argument is not valid.
Action: Check the value entered.