Monday, 6 June 2022

How to allocate initial extent for a partitioned table?

 

In case the parameter deferred_segment_creation is defined as TRUE, the initial extent will only be allocated whenever the data is inserted into the table.

 But how do we do this manually, if needed?

SQL> alter table MY_TABLE allocate extent;

or if the table is partitioned:

SQL> alter table MY_PART_TABLE modify partition   PR001  allocate extent;

No comments:

Post a Comment