HomeOracleOracle Error ORA-14520: Tablespace string block size [string] does not match existing object block size [string]

Oracle Error ORA-14520: Tablespace string block size [string] does not match existing object block size [string]

Oracle Error Message

ORA-14520: Tablespace string block size [string] does not match existing object block size [string]

Reason for the Error

A DDL statement was issued that would require a tablespace of a block size different from the block size of the specified partitioned object to be assigned either: (1) As the object’s default tablespace (or one of the object’s partition-level default tablespaces, if composite partitioning is being used) OR (2) To one of the object’s partitions/subpartitions.

Solution

Specify a tablespace of the same block size as the partitioned object.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...