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

Solution ID:ORA-14523

Type: Oracle

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.

Actions

Specify a tablespace of the same block size as the partitioned object.

Try the following links for this error:

http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm

https://community.oracle.com/message/3933747

https://community.oracle.com/message/3835358

Browse all solutions to database errors from Oracle, MS SQL, or MySQL