Cause | Syntax error occurred. |
Action | Correct the SQL statement. |
Cause | Unsupported DDL (Data Definition Language). |
Action | The statement cannot be executed. |
Cause | The statement is not valid DDL. |
Action | The statement cannot be executed. |
Cause | In the current boot mode, this DDL cannot be executed. |
Action | Change the boot mode and run the DDL statement again. |
Cause | The right parenthesis is missing. |
Action | Check parentheses and try again. |
Cause | The specified filename is too long. |
Action | Use a shorter filename and try again. |
Cause | The specified value is either too small or too large. |
Action | Specify a valid value and try again. |
Cause | The START WITH option was specified for an ALTER sequence. |
Action | The START WITH option is allowed only for CREATE sequences. |
Cause | The number of columns exceeds the maximum number allowed. |
Action | Specify a number of columns less than the maximum. |
Cause | A column privilege was granted to an operation other than INSERT, REFERENCE or UPDATE. |
Action | The privilege cannot be granted. |
Cause | The number of specified files is different from the number of target files. |
Action | Ensure that the numbers of files match. |
Cause | The specified log group number is invalid. |
Action | Specify a valid log group number. |
Cause | The specified option is invalid. |
Action | Specify a valid option. |
Cause | The filename is not specified. |
Action | Specify a valid filename. |
Cause | A duplicate FORCE LOGGING clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate LOGGING clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate PCTFREE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate INITRANS setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate STORAGE clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate MINEXTENTS setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate MAXEXTENTS setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate EXTENT MANAGEMENT clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate ENABLE or DISABLE clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate USING INDEX clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate NULL or NOT NULL setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate primary key exists. |
Action | Delete the duplicate. |
Cause | A duplicate unique key exists. |
Action | Delete the duplicate. |
Cause | A duplicate ENABLE or DISABLE IN ROW setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate CHUNK SIZE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate USER SYS clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate MAXLOGGROUPS setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate MAXLOGMEMBERS setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate MAXDATAFILES setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate NATIONAL CHARACTER SET setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate ARCHIVELOG or NOARCHIVELOG setting exists. |
Action | Delete the duplicate setting. |
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. |
Cause | A duplicate ONLINE or OFFLINE clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate TABLESPACE setting exists. |
Action | Delete the duplicate setting. |
Cause | A column type was omitted. |
Action | Specify a column type. |
Cause | The column definition was omitted. |
Action | Specify the definition. |
Cause | Two or more LONG-type columns are specified in one table. |
Action | Specify only one LONG-type column. |
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. |
Cause | The number of specified columns is different from the number of columns in subquery. |
Action | Ensure that the numbers of columns match. |
Cause | Cannot specify a column data type with a subquery. |
Action | Do not specify a data type. |
Cause | A column contains a NULL value: NOT NULL or primary key cannot be created. |
Action | Check columns for NULL values. |
Cause | A duplicate INCREMENT BY setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate START WITH setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate MAXVALUE or NOMAXVALUE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate MINVALUE or NOMINVALUE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate CYCLE or NOCYCLE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate CACHE or NOCACHE setting exists. |
Action | Delete the duplicate setting. |
Cause | The new password is invalid. |
Action | Specify a valid password. |
Cause | The password is too long. |
Action | Use a shorter password. |
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. |
Cause | The encrypted password is invalid. |
Action | Use a password that is encrypted in a valid style. |
Cause | A duplicate password exists. |
Action | Change to a unique password. |
Cause | A duplicate REPLACE old password statement exists. |
Action | Delete the duplicate statement. |
Cause | A duplicate DEFAULT TABLESPACE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate DEFAULT ROLE clause exists. |
Action | Delete the duplicate clause. |
Cause | A duplicate PASSWORD EXPIRE setting exists. |
Action | Delete the duplicate setting. |
Cause | A duplicate ACCOUNT_LOCK setting exists. |
Action | Delete the duplicate setting. |
Cause | The online datafile cannot be dropped. |
Action | Execute the OFFLINE FOR DROP option first. |
Cause | The END BACKUP option cannot be used for a temporary file. |
Action | Unable to execute. |
Cause | The file was not found in the current database. |
Action | Specify a valid file name. |
Cause | The file was not found in the current database. |
Action | Specify a valid file number. |
Cause | The log member clause was omitted. |
Action | Specify the log member clause. |
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. |
Cause | The specified schema was not found. |
Action | Specify a valid schema name. |
Cause | The specified user was not found. |
Action | Specify a valid user name. |
Cause | The specified role was not found. |
Action | Specify a valid role. |
Cause | The specified object was not found or is an invalid type. |
Action | Specify a valid object name. |
Cause | The specified column was not found or is an invalid type column. |
Action | Specify a valid column name. |
Cause | The specified tablespace does not exist. |
Action | Specify a valid tablespace name. |
Cause | The specified tablespace cannot be used for a default tablespace. |
Action | Specify a different tablespace name. |
Cause | The specified role does not exist. |
Action | Specify a valid role. |
Cause | The specified constraint does not exist. |
Action | Specify a valid constraint name. |
Cause | The specified grantee does not exist. |
Action | Specify a valid target name. |
Cause | The specified revokee does not exist. |
Action | Specify a valid target name. |
Cause | A duplicate column name exists. |
Action | Use a unique column name. |
Cause | In order to change the column datatype, all columns must be empty. |
Action | Clear all columns. |
Cause | Column lengths cannot be reduced if the column is not empty. |
Action | Make the columns null. |
Cause | A duplicate segment name exists. |
Action | Use a unique segment name. |
Cause | A duplicate constraint name exists. |
Action | Use a unique constraint name. |
Cause | The expression requires a column alias. |
Action | Specify a column alias. |
Cause | The number of aliases is different from the number of required columns. |
Action | Specify a valid number of aliases. |
Cause | An index cannot be made of LONG, LONG RAW or LOB type columns. |
Action | Unable to execute. |
Cause | The object does not have columns. |
Action | Check again. |
Cause | A duplicate grantee name exists. |
Action | Delete the duplicate grantee name. |
Cause | A duplicate revokee name exists. |
Action | Delete the duplicate revokee name. |
Cause | A duplicate privilege exists. |
Action | Delete the duplicate privilege. |
Cause | A duplicate role exists. |
Action | Delete the duplicate role. |
Cause | In the CREATE TABLE AS SELECT statement, the LONG type column cannot be specified. |
Action | Do not specify a LONG type column. |
Cause | The synonym and its target have the same name. |
Action | Try a different synonym. |
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. |
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. |
Cause | Unable to create a new object name. |
Action | Avoid any names used internally by DBMS server. |
Cause | A file with that name already exists. |
Action | Specify another file name. |
Cause | A tablespace with that name already exists. |
Action | Specify another tablespace name. |
Cause | A partition with that name already exists. |
Action | Specify another partition name. |
Cause | A role or user with that name already exists. |
Action | Specify another username. |
Cause | A role or user with that name already exists. |
Action | Specify another role name. |
Cause | A schema object with that name already exists. |
Action | Specify another object name. |
Cause | A column with that name already exists. |
Action | Specify another column name. |
Cause | The specified constraint name is already being used. |
Action | Specify another constraint name. |
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. |
Cause | The specified size for the new extent is either too small or too large. |
Action | Specify a valid size for the new extent. |
Cause | The specified file size is either too small or too large. |
Action | Specify a valid file size. |
Cause | The value of INITRANS is either too small or too large. |
Action | Specify an integer value between 1 and 255. |
Cause | The value of PCTFREE is either too small or too large. |
Action | Specify an integer value between 0 and 99. |
Cause | The value of MAXDATAFILES is either too small or too large. |
Action | The number of MAXDATAFILES should be between 10 and 65533. |
Cause | The value of MAXLOGGROUPS is invalid. |
Action | Specify a new value for MAXLOGGROUPS. |
Cause | The value of MAXLOGMEMBERS is invalid. |
Action | Specify a new value for MAXLOGMEMBERS. |
Cause | The next extent or max extent size is invalid. |
Action | Specify a valid extent size. |
Cause | Unsupported character set. |
Action | Specify a supported character set. |
Cause | The specified log file size is either too small or too large. |
Action | Specify a log file size between 512KB and 1GB. |
Cause | The data type of the default expression is invalid. |
Action | Specify a valid expression data type. |
Cause | A segment could not be created in a temporary tablespace. |
Action | Specify a valid tablespace. |
Cause | A segment could not be created in an undo tablespace. |
Action | Specify a valid tablespace. |
Cause | Permanent objects cannot be created in a temp DB. Temp objects cannot be created in a permanent DB. |
Action | Recheck the object. |
Cause | Unable to define foreign key constraint for columns of a global temporary table. |
Action | Unable to execute this command. |
Cause | Tried to specify an invalid clause for the global temporary table. |
Action | Unable to execute this command. |
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. |
Cause | There are more than 32 columns in the index. |
Action | Reduce the number of columns in the index to 32 or less. |
Cause | The specified index already exists. |
Action | Unable to execute this command. |
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. |
Cause | An ALTER or DROP statement cannot be used in an LOB index. |
Action | Unable to execute. |
Cause | System tablespaces cannot be dropped. |
Action | Unable to execute this command. |
Cause | The default temporary or default undo tablespaces cannot be dropped. |
Action | Unable to execute this command. |
Cause | Segments still exist in the tablespace to be dropped. |
Action | Set the INCLUDING option, or drop the segment and retry. |
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. |
Cause | A tablespace for the user does not exist. |
Action | Specify the default tablespace for ALTER USER. |
Cause | One of the partitions in the table belongs to another tablespace. |
Action | Drop the partitioned table and retry. |
Cause | INCREMENT may not be 0. |
Action | Specify a valid INCREMENT value. |
Cause | The next or start value of the sequence must be between MINVALUE and MAXVALUE. |
Action | Specify the MINVALUE and MAXVALUE. |
Cause | The CYCLE option must be used with MINVALUE. |
Action | Specify a MINVALUE. |
Cause | The CYCLE option must be used with MAXVALUE. |
Action | Specify a MAXVALUE. |
Cause | MINVALUE must be less than MAXVALUE. |
Action | Set MINVALUE to be smaller than MAXVALUE. |
Cause | The system user cannot be dropped. |
Action | Unable to execute this command. |
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. |
Cause | The requested object is not partitioned. |
Action | Check whether the specified object is valid. |
Cause | The requested partition does not exist. |
Action | Check whether the specified object is valid. |
Cause | The last partition cannot be dropped. |
Action | Unable to execute. |
Cause | There are more than 32 columns in the constraint. |
Action | Reduce the number of columns in the constraint to 32 or less. |
Cause | The constraint for that reference does not exist. |
Action | Specify a valid constraint. |
Cause | The constraint on the key is not specified. |
Action | Specify a valid constraint. |
Cause | The specified column cannot be used as a constraint. |
Action | Specify a valid column. |
Cause | A table may have only one primary key. |
Action | Specify one primary key. |
Cause | A unique or primary key with that name already exists. |
Action | Delete the duplicate constraint. |
Cause | A reference key with that name already exists. |
Action | Delete the duplicate constraint. |
Cause | A NOT NULL constraint with that name already exists. |
Action | Delete the duplicate constraint. |
Cause | The existing index cannot be used as a constraint for a new object. |
Action | Specify another index. |
Cause | An index was specified for a constraint which does not require an index. |
Action | Retry without specifying an index. |
Cause | The specified index already exists for another object. |
Action | Specify another index. |
Cause | Columns in the specified index do not match with those of the new constraint. |
Action | Specify another index. |
Cause | For the MODIFY COLUMN statement, only NULL or NOT NULL can be specified. |
Action | Unable to execute this command. |
Cause | Referred by other reference constraint. |
Action | Specify the CASCADE CONSTRAINTS clause and retry. |
Cause | The column is already specified as NULL. |
Action | Unable to execute this command. |
Cause | The specified column cannot be NULL. |
Action | Make sure that the column is not specified as containing primary keys. |
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. |
Cause | Unable to create a local partition index for a non-partitioned table. |
Action | Unable to execute this command. |
Cause | The table has a row which violates one or more constraints. |
Action | Modify the row or change the constraint state. |
Cause | The referenced key is disabled: therefore, the foreign key is not available. |
Action | Enable the referenced key first. |
Cause | The specified partition value is invalid. |
Action | Specify a valid partition value. |
Cause | Indexes used as primary/unique key constraints cannot be dropped. |
Action | Unable to execute this command. |
Cause | A connected user cannot be dropped. |
Action | Disconnect the user and try again. |
Cause | Privileges and roles cannot be granted to oneself. |
Action | Unable to execute this command. |
Cause | Roles cannot be granted to themselves. |
Action | Unable to execute this command. |
Cause | Unable to revoke one's own privileges or roles. |
Action | Unable to execute this command. |
Cause | Unable to revoke a role that has not been granted. |
Action | Specify a role that has been granted and try again. |
Cause | Unable to revoke an object privilege that has not been granted. |
Action | Specify a privilege that has been granted and try again. |
Cause | Unable to revoke a system privilege that has not been granted. |
Action | Specify the granted system privilege and try again. |
Cause | Unable to revoke a privilege granted by another user. |
Action | First receive the privilege to revoke and then revoke the user's privilege. |
Cause | Roles cannot be granted circularly. |
Action | Delete the circular GRANT option. |
Cause | Roles cannot be specified when using the GRANT option. |
Action | Unable to execute this command. |
Cause | No privilege to grant. |
Action | Specify a privilege to grant. |
Cause | The ADMIN option can be specified only for system privileges or roles. |
Action | Use the GRANT option instead of the ADMIN option. |
Cause | The ADMIN option can be specified only for system privileges. |
Action | Use the GRANT option instead of the ADMIN option. |
Cause | The specified schema object privilege cannot be granted to the object. |
Action | Check that a valid privilege or object is specified. |
Cause | A role that has not been granted cannot be enabled. |
Action | Specify a role that has been granted to you. |
Cause | Invalid password specified for the role. |
Action | Specify a valid password. |
Cause | The password is needed to enable roles. |
Action | Enter the password. |
Cause | A package specification for the body was not found. |
Action | Check whether or not the package specification exists. |
Cause | The body is already defined for the package. |
Action | Specify or replace and redefine. |
Cause | The object about to be created or updated is dependent on itself. |
Action | Examine the dependencies and modify the source code. |
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. |
Cause | Objects made by the system cannot be modified. |
Action | Unable to execute this command. |
Cause | Parameter name is duplicated. |
Action | Delete the duplicate name. |
Cause | The name of an object belonging to another schema cannot be changed. |
Action | Unable to execute this command. |
Cause | Unable to replace an object with another of a different type. |
Action | Unable to execute this command. |
Cause | Unable to ALTER or DROP an object of a different type. |
Action | Unable to execute this command. |
Cause | Transaction is already started. SET TRANSACTION cannot be executed. |
Action | Unable to execute this command. |
Cause | Failed to load a DDL file. |
Action | Make sure that the file exists. |
Cause | Invalid local transaction ID. |
Action | Check that the specified local transaction ID is valid. |
Cause | The first file of a system tablespace cannot be regenerated. |
Action | Unable to execute this command. |
Cause | For example \"update A or B\" is invalid. |
Action | Unable to execute this command. |
Cause | Invalid directory path. |
Action | Enter an absolute path. |
Cause | Invalid initialization parameter name. |
Action | Recheck the parameter name. |
Cause | This initialization parameter cannot be modified dynamically. |
Action | Restart the server or regenerate the database. |
Cause | The type of initialization parameter required is different from the one defined in DDL. |
Action | Recheck the parameter type. |
Cause | This initialization parameter is out of range. |
Action | Check the parameter range again. |
Cause | This initialization parameter cannot be adjusted by sessions. |
Action | Use ALTER SYSTEM statements, instead of ALTER SESSION. |
Cause | The number of columns used in a constraint exceeds 32. |
Action | Specify a number of columns less than 32. |
Cause | File does not exist or is not accessible. |
Action | Check file name and permissions. |
Cause | The session does not exist. |
Action | Check the session id. |
Cause | Performs dump. |
Action | Normal action. |
Cause | The specified column is already specified as NOT NULL. |
Action | Unable to execute this command. |
Cause | Reserved words cannot be used as identifiers. |
Action | Use another name. |
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. |
Cause | Duplicate clause was found. |
Action | Use only one instance of a clause. |
Cause | Failed to execute an SQL statement used internally in DDL. |
Action | Contact the technical support team. |
Cause | The object about to be created does not match the tablespace type. |
Action | Recheck the statement. |
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. |
Cause | The number of defined log members is larger than MAXLOGMEMBERS. |
Action | Decrease the number of log members or increase the value of MAXLOGMEMBERS. |
Cause | The number of defined partitions exceeds 10,000. |
Action | Reduce the number of partitions to less than 10,000. |
Cause | The value of MAXSIZE is smaller than the size of the file. |
Action | Increase the value of MAXSIZE and the file size. |
Cause | There are constraints that reference the specified constraint. |
Action | Disable or drop the constraints that reference the specified constraint. |
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. |
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. |
Cause | DDL cannot be executed in the remote database. |
Action | Unable to execute this command. |
Cause | The partition type of the given table does not match the input statement type. |
Action | Correct the partition type and retry. |
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. |
Cause | The specified subpartition name is too long. |
Action | Use a shorter partition or subpartition name. |
Cause | A partition other than the last one (or no partition) was set as the default. |
Action | Set the last partition as the default. |
Cause | DEFAULT cannot be used with the values of other partitions. |
Action | Delete the values of other partitions from the default partition. |
Cause | The partition value is duplicated. |
Action | Delete the duplicate partition value. |
Cause | For list partitioning, only one partitioning column can be specified. |
Action | Specify one partitioning column. |
Cause | Invalid clause is specified for an external table. |
Action | Unable to execute this command. |
Cause | Duplicate option was specified. |
Action | Delete the duplicate option and retry. |
Cause | Tables owned by SYS cannot execute DROP COLUMN. |
Action | Unable to execute this command. |
Cause | An attempt was made to delete a column that is used as a partitioning key. |
Action | Unable to execute this command. |
Cause | An attempt was made to delete all columns in the table. |
Action | Unable to execute this command. |
Cause | An attempt was made to drop the reference key column. |
Action | Remove the constraint first, or use CASCADE CONSTRAINTS. |
Cause | The column cannot be modified. |
Action | LOB, LONG, or partitioning key columns cannot be modified. Delete them or add new columns. |
Cause | To decrease column's precision or scale, columns of the all existing rows should be NULL. |
Action | Set column to NULL. |
Cause | An attempt was made to modify a referencing or referenced key column. |
Action | Remove the constraint first and try again. |
Cause | An attempt was made to partition tables with LONG-type columns. |
Action | Unable to execute this command. |
Cause | An attempt was made to use BLOB, CLOB or ROWID-type columns as partitioning columns. |
Action | Unable to execute this command. |
Cause | A new partition cannot be added because one of the partition values is DEFAULT. |
Action | Unable to execute this command. |
Cause | Invalid data type is included in the column. |
Action | Unable to execute this command. |
Cause | The statement is not supported on external tables. |
Action | Unable to execute this command. |
Cause | Duplicate username exists. |
Action | Delete the duplicate user. |
Cause | BY ACCESS/SESSION clauses cannot be used for NOAUDIT clauses. |
Action | Delete the BY ACCESS/SESSION clause. |
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. |
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. |
Cause | The index is being built or rebuilt. |
Action | Wait until the online build is completed. |
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. |
Cause | An attempt was made to perform this task on a disabled index. |
Action | Unable to execute this command. |
Cause | An attempt was made to execute a savepoint while performing a PDML transaction. |
Action | Perform the PDML transaction after committing or rolling back. |
Cause | A table which is not partitioned by RANGE, HASH or LIST methods cannot be moved. |
Action | Unable to execute this command. |
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. |
Cause | A date value should come after a START WITH or NEXT option. |
Action | Specify a date value after START WITH or NEXT option. |
Cause | An attempt was made to execute AUDIT or NODAUDIT on user SYS. |
Action | Unable to execute this command. |
Cause | Invalid encryption algorithm name. |
Action | Specify a value encryption algorithm name. |
Cause | Invalid encryption algorithm or password. |
Action | Check the encryption algorithm or password again. |
Cause | Unable to encrypt data columns of that type. |
Action | Unable to execute this command. |
Cause | The requested object is not encrypted. |
Action | Verify that this is correct. |
Cause | The table is used as a container table of materialized view. |
Action | Remove the materialized view first. |
Cause | The specified PCTTHRESHOLD is either too large or too small. |
Action | Specify a valid PCTTHRESHOLD value. |
Cause | A primary key is necessary. |
Action | Specify a primary key. |
Cause | Composite partitioning is not supported. |
Action | Use another partitioning method. |
Cause | A primary key for an index-organized table must exist at all times. |
Action | Unable to execute this command. |
Cause | A WHEN clause cannot be used in INSTEAD OF triggers. |
Action | Delete the WHEN clause when creating an INSTEAD OF trigger. |
Cause | Cannot create INSTEAD OF triggers on tables. |
Action | Unable to execute this command. |
Cause | Cannot create INSTEAD OF triggers on a read-only view. |
Action | Unable to execute this command. |
Cause | Cannot specify a column list for the trigger. |
Action | Delete the column list. |
Cause | A table or view with the specified name could not be found. |
Action | Verify the table or view name. |
Cause | A view cannot be used for the specified clause. |
Action | Unable to execute. |
Cause | The clause cannot be used for a hash partition. |
Action | Delete the clause. |
Cause | The specified value does not match the column type. |
Action | Specify a value that matches the column. |
Cause | The specified value is too long. |
Action | Specify a value that matches the length of the column. |
Cause | The clause is only available for TAC, and cannot be used for a single instance. |
Action | Remove the clause. |
Cause | Cannot specify subpartition definitions. |
Action | Delete the description. |
Cause | Cannot be executed for a composite partitioned index. |
Action | Unable to execute this command. |
Cause | The numbers of columns in the tables do not match. |
Action | Unable to execute this command. |
Cause | The types of columns in the tables do not match. |
Action | Unable to execute this command. |
Cause | Index key columns in the tables do not match. |
Action | Unable to execute this command. |
Cause | Can be executed only for a local partitioned index. |
Action | Unable to execute this command. |
Cause | Index types and attributes do not match. |
Action | Unable to execute this command. |
Cause | The object is not available due to compiler error(s) that occurred during its creation. |
Action | Check and correct the compiler error(s). |
Cause | The specified object was not removed. |
Action | Unable to execute this command. |
Cause | Not supported in TAC mode. |
Action | Retry this command in single instance mode. |
Cause | Unable to use an encrypted column. |
Action | Unable to execute this command. |
Cause | Some rows cannot be inserted in the specified partition. |
Action | Remove the invalid rows and try again. |
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. |
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. |
Cause | An attempt was made to partition an R-tree index. |
Action | An R-tree index cannot be partitioned. |
Cause | The R-tree index key column is not of GEOMETRY type. |
Action | An R-tree index key column must be of GEOMETRY type. |
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. |
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. |
Cause | There is no materialized view log on the table. |
Action | Check the table name or create a materialized view log on the table. |
Cause | The table does not have a primary key constraint. |
Action | Create a primary key constraint and try again. |
Cause | A primary key column does not exist in the SELECT statement. |
Action | Specify a primary key column in the SELECT or FAST statement. |
Cause | The specified prebuilt table does not exist. |
Action | Try again with the BUILD IMMEDIATE and BUILD DEFERRED options. |
Cause | An attempt was made to use a prebuilt table. |
Action | Try again with the BUILD IMMEDIATE and BUILD DEFFERED options. |
Cause | The table is currently being online redefined. |
Action | Wait until the online redefinition is finished. |
Cause | The table is not being online redefined. |
Action | Unable to execute this command. |
Cause | The column is not encrypted. |
Action | Unable to execute this command. |
Cause | The column is already encrypted. |
Action | Unable to execute this command. |
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. |
Cause | An attempt was made to specify more than one DOMAIN index key column. |
Action | Specify only one DOMAIN index key column. |
Cause | An attempt was made to partition a DOMAIN index. |
Action | Unable to partition the DOMAIN index. |
Cause | XML index key column is not of XMLTYPE type. |
Action | XML index key column must be of XMLTYPE type. |
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. |
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. |
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. |
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. |
Cause | The command does not need to be executed. |
Action | Do not execute the command. |
Cause | The original name is currently being used by another object. |
Action | Use RENAME clause. |
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. |
Cause | Partitioning columns must be contained in index key columns. |
Action | Use non-unique index or ensure the index key columns include partitioning columns. |
Cause | Fast refresh is unavailable because the master table does not have a materialized view log. |
Action | Create a master table materialized view log. |
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. |
Cause | The materialized view log does not have a rowid column. |
Action | Create a materialized view log with rowid. |
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. |
Cause | The materialized view log has no new values information. |
Action | Create a materialized view log containing new values. |
Cause | The materialized view log is not recording necessary filter columns. |
Action | Add filter columns to the materialized view log. |
Cause | The specified object does not exist or is of incompatible type. |
Action | Specify the name of valid object. |
Cause | A materialized view log already exists on the table. |
Action | Use 'alter materialized view log'. |
Cause | The materialized view log already has primary keys. |
Action | The materialized view log does not need more primary keys. |
Cause | The materialized view log already has a rowid. |
Action | The materialized view log does not need another rowid. |
Cause | The materialized view log already has a sequence. |
Action | The materialized view log does not need another sequence. |
Cause | The materialized view log already has new values. |
Action | The materialized view log does not need more new values. |
Cause | The materialized view is currently invalid. |
Action | Perform a complete refresh of the materialized view. |
Cause | The materialized view does not exist. |
Action | Check the materialized view. |
Cause | An attempt was made to explicitly refresh a NEVER REFRESH materialized view (\"%1$s\") |
Action | The materialized view cannot be refreshed. |
Cause | The materialized view log is younger than the last refresh. |
Action | Perform a complete refresh. |
Cause | An attempt was made to specify an invalid type key column. |
Action | Specify only char/varchar type key columns. |
Cause | An attempt was made to specify an invalid parameter value. |
Action | Check the parameter value. |
Cause | An ALTER or DROP statement cannot be used in the domain indexed column. |
Action | Unable to execute. |
Cause | Domain index is invalid. |
Action | Unable to execute. |
Cause | Partition key column of local partition index should be a subset of index key column. |
Action | Unable to execute. |
Cause | ROWIDs of certain tables were missing in the definition. |
Action | Specify the FORCE or COMPLETE option. |
Cause | This materialized view does not support the fast refresh after deletion or updates. |
Action | Use the complete refresh. |
Cause | Conditions for refresh at commit time were not satisfied. |
Action | Specify valid options. |
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. |
Cause | Sequence cache size is larger than one cycle. |
Action | Increase the cycle, or decrease the cache size. |
Cause | An expression that cannot be resolved is included in the index key column. |
Action | Unable to execute the command. |
Cause | An expression that cannot be resolved is included in the check condition. |
Action | Unable to execute the command. |
Cause | Too many error codes are specified. |
Action | Decrease the number of error codes. |
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. |
Cause | The specified PCTTHRESHOLD is incorrect. |
Action | Specify PCTTHRESHOLD between 1 and 50. |
Cause | Index-Organized Table cannot include a LONG type column. |
Action | Delete the LONG type column. |
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. |
Cause | An OVERFLOW segment must be specified when INCLUDING is specified or the number of column exceeds 255. |
Action | Specify an OVERFLOW segment. |
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. |
Cause | In the massive cluster system, this DDL cannot be executed. |
Action | Unable to execute. |
Cause | A slave node is not operating. |
Action | Unknown cause of error. |
Cause | The specified event conditional clause is incorrect. |
Action | Check the conditional clause of the event to be handled. |
Cause | The specified profile was not found or is an invalid type. |
Action | Specify a valid profile name. |
Cause | There is a user who uses the profile. |
Action | Try again using the CASCADE option. |
Cause | The specified temporary tablespace cannot be dropped because it is in use. |
Action | Wait until the temporary tablespace is inactive. |
Cause | System tablespaces cannot be renamed. |
Action | Unable to execute this command. |
Cause | The value of the initialization parameter is not an absolute path. |
Action | Ensure the value of the initialization parameter is an absolute path. |
Cause | The specified log group does not exist. |
Action | Check the log group. |
Cause | The supplemental logging attribute does not exist. |
Action | Check the supplemental logging attribute. |
Cause | The supplemental logging attribute already exists. |
Action | Check the supplemental logging attribute. |
Cause | The input value must be an integer. |
Action | Use an integer value expression as the input. |
Cause | The table must not have any bitmap indexes. |
Action | Ensure bitmap indexes do not exist on this table. |
Cause | The appropriate resource limit should be provided. |
Action | Ensure the resource limit is valid. |
Cause | Partitioned IOT is not supported. |
Action | Unable to execute this command. |
Cause | In the massive cluster system, this DDL cannot be executed. |
Action | Unable to execute. The table needs a hash data sharding property. |
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. |
Cause | BUCKET option is not permitted on non-hash data sharding. |
Action | Unable to execute. The table needs a hash data sharding property. |
Cause | Specified bucket number is not correct. |
Action | Check bucket number by _DD_TABLET_MEMBER. |
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. |
Cause | Creating the diskspace failed due to an unknown reason. |
Action | Check the logs. |
Cause | A diskspace with the same name already exists. |
Action | Check the diskspace name. |
Cause | Another diskspace is already using the disk. |
Action | Check the path to the disk. |
Cause | The disk has been assigned already. |
Action | Check the path to the disk. |
Cause | The number of diskspace is full. |
Action | Check the number of available diskspace. |
Cause | Failed to open the disk. |
Action | Check the logs. |
Cause | Failed to read from the disk. |
Action | Check the logs. |
Cause | Failed to write to the disk. |
Action | Check the logs. |
Cause | Only file, raw device, or symbolic link can be used as device type. |
Action | Check the device type. |
Cause | The specified disk size is too big or invalid. |
Action | Check the disk size. |
Cause | The specified file size is too large or invalid. |
Action | Compare the file size to the number and size of disks. |
Cause | The specified sector size does not match the device sector size. |
Action | Check the device sector size. |
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. |
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. |
Cause | The maximum number of disks allowed for a diskspace is 65535. |
Action | Check the number of disks required for the DDL statement. |
Cause | Specified group name is not correct. |
Action | Check group name by horde configuration. |
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. |
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. |
Cause | Cannot move to another group. |
Action | Check group name or use FORCE keyword. |
Cause | Specified group name is not correct or group is empty. |
Action | Check group name or group configuration. |
Cause | Specified tablet number is not correct. |
Action | Check tablet number by _dd_tablet_member. |
Cause | Index-organized tables are not supported. |
Action | Use supported sharding methods. |
Cause | Delete cascade feature is not supported. |
Action | Do not use the delete cascade feature in TMC. |
Cause | Bucket number should be specified on hash shading. |
Action | Specify a bucket number from _DD_TABLET_MEMBER. |
Cause | Specified node number is not correct. |
Action | Check node number by horde (show TMC). |
Cause | In the single system, this DDL cannot be executed. |
Action | Unable to execute. |
Cause | Delete set null feature is not supported. |
Action | Do not use the delete set null feature in TMC. |
Cause | Primary index on an IOT cannot be rebuilt. |
Action | Use Alter table MOVE to reorganize the IOT. |
Cause | Try again. |
Action | Try again. |
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. |
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. |
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. |
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). |
Cause | A valid serial number must be provided to apply a SESSION KILL request to a session. |
Action | Check the session serial number. |
Cause | SESSION KILL request can be only applied to a ACTIVE or RUNNING session. |
Action | Check the session status. |
Cause | Unable to modify the primary key column value of an index-organized table. |
Action | Modify the column using the DBMS.REDEFINITION package. |
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. |
Cause | Current database uses Text-TIP. |
Action | Restart the server using btip. |
Cause | Verify the file name is valid. |
Action | Verify the file name is valid. |
Cause | Verify the BTIP file name. |
Action | Verify the BTIP file name. |
Cause | Verify the TIP file name. |
Action | Verify the TIP file name. |
Cause | The specified file already exists. |
Action | Unable to execute this command. |
Cause | Ensure the file path and permissions are correct. |
Action | For more information, check the errno in tracelog. |
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. |
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. |
Cause | An attempt was made to truncate a read-only table. |
Action | Read-only tables cannot be truncated. |
Cause | There has been an attempt to change the SYS account into a LOCK status. |
Action | Cannot execute the DDL statement. |
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. |
Cause | More than one auto increment exists in the table. |
Action | Specify only one auto increment column in the table. |
Cause | Cannot recompile a PSM object while executing a parallel query. |
Action | Serially execute the query, or retry after recompiling the invalid OBJ. |
Cause | Cannot perform the encryption operation for the encrypted tablespaces. |
Action | Cannot perform the command. |
Cause | Cannot rename a materialized view or its base table. |
Action | Cannot execute the command. |
Cause | An index cannot be made of ROWID type column. |
Action | Unable to execute. |
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. |
Cause | INCREMENT must be less than MAXVALUE minus MINVALUE. |
Action | Unable to execute. |
Cause | The function has yet been implemented. |
Action | The command cannot be run. |
Cause | Tried to specify an invalid clause for the virtual table. |
Action | Unable to execute this command. |
Cause | The specified tablespace cannot be used for a temporary tablespace. |
Action | Specify a different tablespace name. |
Cause | SESSION CLEAN request can be only applied to a ASSIGNED session. |
Action | Check the session status. |
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. |
Cause | The specified value must be a positive integer greater than or equal to MINEXTENTS. |
Action | Specify an appropriate value. |
Cause | The specified value must be a positive integer less than or equal to MAXEXTENTS. |
Action | Specify an appropriate value. |
Cause | ERROR : malloc failed due to a lack of memory space in the system. |
Action | Increase the memory space in the system. |
Cause | IP already exists. |
Action | Specify another IP. |
Cause | The absolute path of a datafile have to include @SID@ in TMC. |
Action | Insert @SID@ into absolute path. |
Cause | The absolute path of a datafile is not correct. |
Action | Please check the path of a datafile. |
Cause | An invalid IP address is given as a DDL paramter. |
Action | Check the parameter and specify an appropriate value. |
Cause | Properties of the specified table is different with partition |
Action | Change properties of the table. |
Cause | Another session is holding the lock. |
Action | Try again later. |
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. |
Cause | This error is called by the user defined error in PSM. |
Action | Check the PSM that contains the user defined error. |
Cause | Flashback operation attempts to flash back objects other than tables. |
Action | Check the type of the object being flash backed. |
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. |
Cause | cannot reuse lower-bound partitions resulting partition. |
Action | use upper_bound partition. |
Cause | range partitions being merged are not adjacent |
Action | specify two partition that are adjacent |
Cause | The table and the partition of the composite partition cannot be exchanged. |
Action | Specify a subpartition. |
Cause | Cannot redefine an object online that is not a table |
Action | Specify a table |
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 |
Cause | An invalid thread ID given as a DDL parameter. |
Action | Specify a valid thread ID as a DDL parameter. |
Cause | Specified data type is invalid, or the user-defined type does not exist. |
Action | Please recheck the data type specified in the column. |
Cause | Cannot use shrink space on an object with disabled row movement. |
Action | Enable row movement for the object. |
Cause | Cannot use shrink space on an object that has a long column. |
Action | Unable to execute this command. |
Cause | The interval value is invalid. |
Action | Change the interval value to an appropriate type. |
Cause | The number of partition columns in an interval table must be one. |
Action | Set the number of partition columns to o |
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. |
Cause | The constraints of two tables do not match in \"ALTER TABLE EXCHANGE PARTITION\". |
Action | Please check the constraints. |
Cause | User name or role does not conform to a user rule. |
Action | Check the user rule for CREATE USER. |
Cause | At least one column has long type. |
Action | Avoid using a long column type when creating an external table. |
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. |
Cause | The value of INITRANS is either too small or too large. |
Action | Specify an integer value between 2 and 255. |
Cause | The virtual column is altered to have a default value. |
Action | Remove the default value from the virtual column. |
Cause | The real column is altered to have an expression. |
Action | Remove the expression from the real column. |
Cause | A primary key on an IOT cannot be unusable. |
Action | Unable to execute. |
Cause | User attempted to create a bitmap index on an index-organized table. |
Action | Unable to execute this command. |
Cause | Verify the port is valid. |
Action | Verify the port is valid. |
Cause | Verify the port is valid. |
Action | Verify the port is valid. |
Cause | Verify the port is valid. |
Action | Verify the port is valid. |
Cause | Verify the port is valid. |
Action | Verify the port is valid. |
Cause | Verify the port is valid. |
Action | Verify the port is valid. |
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. |
Cause | The reference partition can be created only if its parent table is partitioned. |
Action | Check if the parent table referenced is partitioned. |
Cause | The specified option is invalid. |
Action | Specify a valid option. |
Cause | Verify the BTIP file name. |
Action | Verify the BTIP file name. |
Cause | Verify the TIP file name. |
Action | Verify the TIP file name. |
Cause | Database cannot be renamed in series. |
Action | Reboot to mount mode. |
Cause | A reference-partitioned table cannot be altered. |
Action | Unable to execute this command. |
Cause | A proxy user option cannot be applied to SYS. |
Action | Unable to execute this command. |
Cause | Index-Organized Table cannot include a LOB or LONG type column. |
Action | Delete the LOB or LONG type column. |
Cause | The user names of the snapshots are not the same. |
Action | Check the user names of the snapshots. |
Cause | Some components of of change manage package are missing. |
Action | Check the requirements of DBMS_CMGT package. |
Cause | The dd snapshot for SYS user cannot be created. |
Action | Try other users for snapshots. |
Cause | Snapshot(s) or object(s) are not found. |
Action | Check if inputs associated with snapshots are correct. |
Cause | Unable to shrink the temporary file. |
Action | Check the properties of the temporary file. |
Cause | The specified value of 'KEEP' paramter is either too small or too large. |
Action | Check the parameter and specify an appropriate value. |
Cause | ADT cannot be declared as a unique or primary key. |
Action | ADT cannot be declared as a unique or primary key. |
Cause | Index-Organized Table cannot include a ADT column. |
Action | Delete the ADT column. |