1

Topic: segment creation deferred - subpartitions

Is oracle 12.1
We create the table with partition by range (1 day) subpartion by hash (128) segment creation deferred
As a result at an insertion of a unique line in new partition we receive selection of a place for all 128 subpartion for this partition (it is visible in user_segments)
This expected behavior?
Dock speaks:
https://docs.oracle.com/en/database/ora … CA352EC298
Creating automatic list composite partitioned tables and interval subpartitions can save space because these methods only create subpartitions in the presence of data. Deferring subpartition segment creation when creating new partitions on demand ensures that a subpartition segment is only created when the first matching row is inserted.
- It to understand as soon as list composite partitioned tables and interval subpartitions work by a principle create subpartitions in the presence of data - and remaining ALWAYS create ALL subpartition segment?