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