Database DataWarehousing (MOSC)

MOSC Banner

Deferred_Segment_Creation and adding partitions to Reference type partitioned tables

When I add partitions to the referenced table in Oracle 19c (19.7), deferred_segment_creation seems to be ignored. When the tables were created, no segments were created. But when I alter the referenced table to add partitions (split into full years worth of partitions in one statement), every new partition for the partitioned tables (10000s of segments) was created (8M for tables, 64K for indexes). Does anyone know what is going on? Do I have any option to get rid of the segments without shrinking and fragging the tablespace? This is a vendor database where most

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center