{"id":2127,"date":"2016-08-19T13:52:31","date_gmt":"2016-08-19T10:52:31","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2127"},"modified":"2016-12-13T13:53:38","modified_gmt":"2016-12-13T10:53:38","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02500-to-ora-02600","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02500-to-ora-02600\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02500 to ORA-02600"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02500 to ORA-02600<\/strong><\/p>\n

\n
ORA-02500: IN SHARD option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the CREATE TABLESPACE, the IN SHARD option was specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all but one of the IN SHARD options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02501: invalid option for CREATE TABLESPACE SET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option IN SHARD was specified for the CREATE TABLESPACE SET statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the invalid option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02502: USING TEMPLATE can only be used in CREATE TABLESPACE SET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to specify the TEMPLATE option without the CREATE TABLESPACE SET statement failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the USING TEMPLATE option in the CREATE TABLESPACE SET statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02503: USING TEMPLATE option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the CREATE TABLESPACE SET, the USING TEMPLATE option was specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all but one of the USING TEMPLATE options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02504: SHARDSPACE does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A nonexistent SHARDSPACE was specified in the CREATE TABLESPACE or CREATE TABLESPACE SET statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reissue the CREATE TABLESPACE or CREATE TABLESPACE SET statement with valid SHARDSPACE name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02505: IN SHARDSPACE option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the CREATE TABLESPACE SET, the IN SHARDSPACE option was specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all but one of the IN SHARDSPACE options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02506: CREATE TABLESPACE SET statement requires the SHARDSPACE keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHARDSPACE option was not specified in the CREATE TABLESPACE SET statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax. Insert the missing keyword where required and then retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02507: missing SHARDSPACE keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHARDSPACE keyword was omitted in the IN SHARDSPACE option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax. Insert the keyword SHARDSPACE where required and then retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02508: attempted to create a shard tablespace in a non-shard database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a shard tablespace in a non-shard database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Deploy the sharding environment before creating a shard tablespace.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-02509: A SHARDSPACE cannot handle several PARTITIONSETS.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to define multiple PARTITIONSETS in the SHARDSPACE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the different PARTITIONSETS in different SHARDSPACES.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02510: A tablespace set cannot be referenced at the table level.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to reference a tablespace set at the table level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the reference to the tablespace set at the table level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02511: SQL query not allowed; the shard DDL is disabled.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to run a shard DDL on a nondeployed shard or with the shard DDL option disabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Deploy the shards or enable shard DDL before executing the DDL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02512: only one PARTITIONSET option may be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The CREATE TABLE statement contained more than one PARTITIONSET option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify PARTITIONSET option at most once in the CREATE SHARDED TABLE statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02513: invalid sharded table PARTITIONSET method<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid PARTITIONSET method was specified in the CREATE TABLE statement. A table may be partitioned by RANGE or LIST.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify PARTITIONSET method to RANGE or LIST in the CREATE SHARDED TABLE statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02514: list PARTITIONSET method expects a single partitioning column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of columns in a PARTITIONSET column list exceeded the legal limit of one for list partitioned tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify PARTITIONSET column list so that it consists of at most one column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02515: cannot interval partition set a sharded table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Interval PARTITIONSET was not supported for a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a LIST or RANGE PARTITIONSET instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02516: invalid SHARDED type specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Only tables can have the SHARDED type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the SHARDED option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02517: PARTITIONSET and CLUSTER clauses are mutually exclusive<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0definition of a table with both PARTITIONSET and CLUSTER clauses which is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the PARTITIONSET or the CLUSTER clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02518: invalid PARTITIONSET clause specified in a non sharded table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0definition of a non sharded table with PARTITIONSET clause is illegal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove the PARTITIONSET clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02519: cannot perform cross-shard operation. Chunk “string<\/i>” is unavailable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0All shards where this chunk is stored were unavailable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rerun the command when the shards become avalaible.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02520: Shard data object number exceeds UB4MAXVAL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0All shards where this chunk is stored were unavailable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rerun the command when the shards become available.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02521: attempted to enable shard DDL in a non-shard database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to enable shard DDL in a non-shard database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Deploy the sharding environment before enabling shard DDL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02522: cannot get a new data object number range from the Global Data Services (GDS) catalog<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to get a new range of data object numbers which resulted in a failure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the shard can connect to the catalog.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02523: The table being created is not SHARDED.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PARENT clause was specified on a non-sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a SHARDED table or remove the PARENT clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02524: Invalid parent table specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The parent table specified was not a valid identifier.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the parent table specified is valid.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02525: child and parent table owner mismatch.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The child and parent tables did not have the same owner.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the owner of the child table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02526: child and parent table sharding method mismatch.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The child and parent tables did not have the same sharding method.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the sharding method for the two tables is the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02527: child and parent table shard key columns mismatch.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The child and parent tables did not have the same shard key columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the shard key for the two tables is the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02528: child and table partition set key columns mismatch.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The child and parent tables did not have the same partition set key columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the partition set key for the two tables is the same.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02529: invalid parent table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table name specified was not the one of the root table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the root table name specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02530: parent table not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a child table without specifying the PARENT clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the PARENT clause in the CREATE SHARDED TABLE command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02531: shard name not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a sharded table on a non-sharded database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the sharded database was deployed correctly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02532: sharding columns must form a subset key of key columns of a UNIQUE index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a primary key constaint on non-sharding columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the sharding columns as a prefix of key columns of a UNIQUE index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02533: missing PARTITION clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The PARTITION clause was expected but was not supplied.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add a PARTITION clause to the CREATE SHARDED TABLE command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02534: invalid PARTITION clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The PARTITION clause was supplied with CONSISTENT HASH sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the PARTITION specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02535: missing TABLESPACE SET clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE SET clause was expected but was not supplied.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add the TABLESPACE SET clause to the CREATE SHARDED TABLE command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02536: invalid TABLESPACE SET name:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE SET supplied did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply a valid TABLESPACE SET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02537: Data file name specified but not supported by tablespace set template<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Data file explicit name was specified as part of the tablespace set template. Only Oracle Managed Files are supported by a tablespace set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the file name from the data file definition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02538: invalid TABLESPACE SET clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE SET clause was not expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the keyword SET to specify just TABLESPACE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02539: the operation is not supported across shards<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform an operation with shard DDL enabled, which is not supported for propagation from catalog to shards.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Disable the shard DDL to perform the operation on the catalog and go to each individual shard to perform the operation locally.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02540: global indexes are not supported for sharded tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a global index on a sharded table, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a local index instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02541: TABLESPACE SET is required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE SET clause was not supplied when creating an index on a system-managed sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add the TABLESPACE SET clause to the CREATE INDEX command, or use the same tablespace set as the table by not specifying the TABLESPACE SET clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02542: invalid partitioning method specified with user-defined sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The partitioning method specified was not compatible with user-defined sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a supported partitioning method.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02543: invalid partitioning method specified with system-managed or composite sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The partitioning method specified was not compatible with system-managed or composite sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a supported partitioning method.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02544: sharding or partition set column datatype is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Supported data types were not used for the sharding or partition set columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the supported data types for sharding or partition set columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02545: sharding or partition set column can not be a virtual column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Virtual column was used in the sharding or partition set key, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the virtual column from the sharding or partition set key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02546: The LONG data type is not supported for duplicated tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified while creating duplicated tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the option specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02547: Option\u00a0string<\/i>\u00a0is not supported for duplicated tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified while creating duplicated tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the option specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02548: Option\u00a0string<\/i>\u00a0is not supported for duplicated tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified while altering duplicated tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the option specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02549: cannot create a sharded table with index organization<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create an index-organized sharded table. This is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a heap-organized table and the primary key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02550: Creating duplicated table not allowed when shard DDL is disabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Duplicated tables were created when shard DDL was disabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable shard DDL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02551: Truncate table for duplicated tables is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Invalid operation was specified on a duplicated table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use “delete from\u00a0table<\/i>” instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02552: invalid shard name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shard name specified was not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a valid shard.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02553: TABLESPACE is required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE clause was not supplied when specifying a partition of a user-defined sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add the TABLESPACE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02554: invalid DROP TABLESPACE SET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The DROP TABLESPACE SET command was not compatible with user-defined sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a supported sharding method.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02555: Online redefinition is not supported for sharded and duplicated tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform online redefinition on a sharded table or a duplicated table for sharding, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the ALTER TABLE statement instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02556: Only sharded or duplicated tables are supported across shards.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a non-sharded, non-duplicated table across shards, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Connect to each shard and create the table locally.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02557: cannot operate on sharded objects when shard DDL is disabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to operate on a sharded or a duplicated object across shards when the shard DDL was not enabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable shard DDL to perform the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02558: cannot operate on non-sharded objects when shard DDL is enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to ALTER or DROP a non-sharded object when the shard DDL was enabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Disable shard DDL to perform the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02559: The TABLESPACE SET\u00a0string<\/i>\u00a0does not belong to the shardspace of the table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TABLESPACE SET supplied existed in a different shardspace from the one to which the table belonged.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply a valid TABLESPACE SET in the shardspace of the table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02560: cannot modify partitions for system-managed or composite sharded tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to modify partitions on system-managed or composite sharded tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the ‘gdsctl split chunk’ or ‘move chunk’ commands instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02561: maximum number of columns in a duplicated table without primary key is 999<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a duplicated table with 1000 columns when there was no primary key defined. Note that unused columns in the table are counted toward the 1000 column limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the number of columns in the command and resubmit.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02562: cannot create a duplicated table in a non-shard schema<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a duplicated table in a non-shard schema.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try creating the duplicated table in a sharded schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02563: XMLType column in a duplicated table cannot be used in non-ASSM tablespace “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0XMLType column in a duplicated table required an automatic segment space management (ASSM) tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify an ASSM tablespace for the XMLType column in a duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02564: rebuild outline is not supported across shards.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to rebuild an outline with shard DDL enabled, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Connect to each shard and rebuild the outline locally.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02565: cannot use individual chunk tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An individual chunk tablespace which was part of a tablespace set was used.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a normal tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02566: cannot create duplicated table – insufficient privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a duplicated table when the user did not have sufficient privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the user has CREATE DATABASE LINK and CREATE MATERIALIZED VIEW privileges before creating a duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02567: cannot create a sharded table with empty columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a sharded table without any columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use valid columns to create a sharded table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02568: cannot create an identity column in a sharded table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a sharded table with an identity column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a sharded table without an identity column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02569: cannot drop a system tablespace\u00a0string<\/i>\u00a0when sharding environment is deployed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a system tablespace part of the sharding environment when the sharding environment was deployed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not drop a tablespace created by the system.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02570: cannot alter user password – insufficient privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to alter the password for a user who created duplicated tables but did not have the privilege to execute the ALTER DATABASE LINK statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the user, whose password has to be changed, has the ALTER DATABASE LINK privilege and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02571: ALTER TABLE TRUNCATE PARTITION for duplicated tables is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid operation was specified on a duplicated table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use DELETE FROM table_name PARTITION (partition_name) instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02572: A non all-shard user cannot operate on schema objects that are sharded or duplicated on all shards.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to operate on a sharded or duplicated schema object by a non all-shard user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Operate on such objects as an all-shard user.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02573: cannot enable shard DDL when current_schema has been changed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Shard DDL is not supported after a session’s current schema has been altered.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reconnect as the correct user to perform shard DDL operations.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02574: Sharded table cannot be a nested table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a nested sharded table, which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a non-nested sharded table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02575: Invalid sharding method for a deployed sharded database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid sharding method was set for a sharded database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the database configuration and correct the settings.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02576: number of partition set specifications is less than number of shardspaces<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Fewer number of partition set specifications were specified than the number of shardspaces in the composite sharding environment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one partition set specification for each shardspace in the composite sharding environment.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02577: cannot specify PARTITIONSET in a non-composite sharding environment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PARTITIONSETS were specified while creating a sharded table in non-composite sharding environment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the PARTITION SET specifications in the create sharded table statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02578: missing PARTITIONSET specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PARTITIONSET specifications were missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify PARTITIONSETS for the sharded table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02579: cannot create a tablespace set with SMALLFILE option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a tablespace set with the SMALLFILE option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a tablespace set with the default BIGFILE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02580: cannot add or drop data files from a tablespace set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to add or drop a data file from a tablespace set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not add or drop a data file from a tablespace set.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02581: cannot create foreign key constraints on columns referencing a duplicated table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a foreign key constraint in a sharded table on a column referencing a duplicated table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the foreign key constraint referencing a column in the duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02582: invalid tablespace set name specified for the partition set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The tablespace set name specified for the paritition set was either invalid or belonged to a different shardspace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a tablespace set name that belongs to the same shardspace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02583: option PARALLEL not supported when creating duplicated table as select from another table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a duplicated table as select from another table in parallel mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a duplicated table as select without the PARALLEL clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02584: INMEMORY options not supported for duplicated tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create or alter a duplicated table by enabling INMEMORY options.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the option specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02585: create tablepsace set failure, one of its tablespaces not created<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the tablespaces in the tablespace set was not created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the creation of the tablespaces.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02586: cannot change duplicated table refresh rate in a non-catalog database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to change the dupl_table_refresh_rate in the non-catalog database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Connect to the catalog database to change the refresh rate of duplicated tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02587: create duplicated table of Object Type is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a duplicated table of object type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a duplicated table without specifying the object type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02588: minimum refresh rate for duplicated table is 20 seconds<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to change the dupl_table_refresh_rate to less than 20 seconds.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set the refresh rate for duplicated tables to atleast 20 seconds.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02589: invalid partition set name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid partition set name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid partition set name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02590: invalid sequence of partition sets<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The sequence used to specify partition sets was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the partition sets in an increasing order.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02591: cannot specify tablespace set for indexes on a sharded table in composite sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify a tablespace set for indexes on a sharded table in a composite sharding environment which is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create index on sharded tables without the tablespace set clause in the composite sharding environment.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02592: cannot drop user until all shard databases are up and all gsm_requests are completed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a user who owns a duplicated table when the shard database was down or the gsm_requests were pending execution.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all gsm_requests are completed and all shards are up before dropping a user with duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02593: cannot drop duplicated table until all shard databases are up and all gsm_requests are completed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a duplicated table when the shard database was down or the gsm_requests were pending execution.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all gsm_requests are completed and all shards are up before dropping a duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02594: cannot alter shard user password until all shard databases are up and all gsm_requests are completed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to alter shard user password when the shard database was down or the gsm_requests were pending execution.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all gsm_requests are completed and all shards are up before altering a shard user password.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02595: Abstract data type is not supported for duplicated tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified while creating duplicated tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the option specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02596: cannot truncate duplicated table on a shard database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to truncate a duplicated table on a shard database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Connect to the catalog database to truncate the duplicated table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02597: The read-only option is not supported for sharded tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified while creating a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the specified option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02598: tablespace specified in the SQL command does not exist in the shard<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A DROP or ALTER TABLESPACE operation was attempted on a shard where the tablespace does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the tablespace in the shard first.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02599: cannot drop partitionset column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a column used as the super-partitioning key for a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This action is not allowed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02600: credential name is invalid:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid credential name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify credential name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02500 to ORA-02600 ORA-02500: IN SHARD option already specified Cause:\u00a0In the CREATE TABLESPACE, the IN SHARD option was specified more than once. Action:\u00a0Remove all but one of the IN SHARD options. ORA-02501: invalid option for CREATE TABLESPACE SET Cause:\u00a0An invalid option IN SHARD was specified for…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2127","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-yj","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2127"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2127\/revisions"}],"predecessor-version":[{"id":2128,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2127\/revisions\/2128"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2127"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}