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 or subpartition of a local index or LOB column to be co-located with the corresponding partition or subpartition of the base table. However, this is not possible because the block sizes of the table and the LOB column or 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 or LOB column and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions or 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.
Cause: A DDL statement was issued that would require a partition or subpartition of a local index or LOB column to be co-located with the corresponding partition or subpartition of the base table. However, this is not possible because the block sizes of the table and the LOB column or 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 or LOB column and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions or 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.
No comments:
Post a Comment