ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]
Cause: A DDL statement was issued that would require a partition/subpartition of a local index/LOB column to be co-located with the corresponding partition/subpartition of the base table. However, this is not possible because the block sizes of the table and the LOB column/local index are different.
Action: Either (1) Specify an object-level default tablespace (or partition-level default tablespace for the appropriate partition, if composite partitioning is used) for the partitioned local index/LOB column 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. Also ensure that neither of TABLESPACE DEFAULT and STORE IN (DEFAULT) is specified for a local index whose block size does not match that of the base table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14523：不能将字符串字符串的[sub]分区与table [sub]分区共存，因为字符串块大小[ 字符串 ]不匹配表块大小[ 字符串 ],
.原因：发出了一个DDL语句，该语句要求本地索引/ LOB列的分区/子分区与基表的相应分区/子分区位于同一位置。然而，这是不可能的，因为表的块大小和LOB列/本地索引是不同的。,
.操作：（1）为分区本地索引/ LOB列指定对象级缺省表空间（或适当分区的分区级缺省表空间，如果使用复合分区），然后重试DDL命令OR（2）确保为正在创建的所有新分区/子分区指定正确块大小的表空间。还要确保为块大小与基表的大小不匹配的本地索引指定TABLESPACE DEFAULT和STORE IN（DEFAULT）。,
.

aiaiDBA

13718043309

010-86462881

ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

1 个回答

相似问题