重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-14523: Cannot co-locate [sub]partition [打印本页]

作者: admin    时间: 2016-8-21 10:52
标题: ORA-14523: Cannot co-locate [sub]partition
ORA-14523: Cannotco-locate [sub]partition of stringstring with table [sub]partition
because
stringblock size [string] does not match table block size [string]
Cause:
A DDL statement was issued that would require apartition/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 becausethe
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 isused)
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.







欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2