Common Questions and Errors on Partition Operations Involving Tablespaces of Different Block Sizes
(Doc ID 1401064.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
Answer questions and address common errors when tablespaces of different block sizes are used during partition operations.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Questions and Answers|
|Can i store different partitions of the same table in tablespaces of different block sizes?|
|Can i store different partitions of an index (global or local) in tablespaces of different block sizes?|
|Can i store the lob in a tablespace of different blocksize as that of the table partition?|
|Where can i find partitioning restrictions for multiple block sizes documented?|
|ORA-14519: Conflicting tablespace blocksizes for table Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]|
|ORA-14520 Tablespace string block size [string] does not match existing object 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]|