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

Cause DB link name is too long.

Action Use a shorter DB link name.

7220: Host name is too long (maximum of %1$d characters).

Cause Host name is too long.

Action Use a shorter host name.

Cause The specified DB link name is already being used.

Action Specify a different DB link name.

Cause The specified DB link does not exist or is an invalid type.

Action Provide a valid DB link 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.

Cause The specified database link does not exist.

Action Check the database link name.

Cause The remote container table function of the materialized view is only supported for Tibero and Oracle.

Action Confirm that the database link is for Tibero or Oracle.

Cause When using a database link, only the ON PREBUILT TABLE option is supported.

Action When creating a materialized view, use the statement \"ON PREBUILT TABLE AT database_link_name.\"

Cause Prebuilt table does not exist in the specified database link position.

Action When creating a materialized view, create a prebuilt table first.

Cause To use REFRESH WITH ROWID when a database link 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: 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.

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 LGWR ASYNC or ARCH ASYNC.

Cause Cascading standby only supports LGWR ASYNC or ARCH ASYNC.

Action Cascading standby only supports LGWR ASYNC or ARCH ASYNC.

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.

Cause The specified virtual database name is already in use.

Action Specify another virtual database name.

Last updated