ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
Cause: 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.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14521：默认表空间字符串块大小[ 字符串 ]为字符串字符串不匹配现有字符串块大小[ 字符串 ],
.原因：发出了一个DDL语句，该语句需要在现有分区对象的对象级缺省表空间中创建新的分区/子分区。但是，对象级缺省表空间块大小与分区对象的块大小不匹配。,
.操作：（1）将分区对象的默认表空间修改为与对象块大小相同的表空间，然后重试DDL命令OR（2）确保为所有新分区指定正确块大小的表空间/子分区。,
.

aiaiDBA

13718043309

010-86462881

ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 个回答

相似问题