Placement Into Tablespaces of Interval Partitions Are Not Round Robin (Doc ID 1552239.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

Interval partitioned table is created with a list of tablespaces in the STORE IN clause:

INTERVAL ...STORE IN (tbs1, tbs2, tbs3)

but the actual interval partitions created are not placed into the above tablespaces in a round robin fashion.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms