My Oracle Support Banner

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 11.2.0.1 and later
Information in this document applies to any platform.

Purpose

Answer questions and address common errors when tablespaces of different block sizes are used during partition operations.

Questions and Answers

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
Purpose
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]
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.