In this post, you’ll learn more about the Oracle ErrorORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string] with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
Reason for the Error ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
A DDL statement was issued that would require creation of a new partition/subpartition in the object-level default tablespace of an existing partitioned object. However, the object-level default tablespace block size does not match the block size of the partitioned object.
How to fix the Error ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string] ?
You can fix this error in Oracle by following the below steps
Either (1) Modify the default tablespace of the partitioned object to a tablespace of the same block size as the object and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions/subpartitions being created.