How to pre-create or materialize segments on 11g for existing tables
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
In 11g by default Segment creation is deferred(segments not created at time of table creation)
when you create normal tables or partition tables.
For knowing the concept of Deferred Segment Creation in 11g you can refer below note :
11.2 Database New Feature Deferred Segment Creation [Video] (Doc ID 887962.1)
Sometimes You may decide to pre-create or materialize segments for tables
that is already created in the database.
Then you can achieve that using DBMS_SPACE_ADMIN.MATERIALIZE_DEFERRED_SEGMENTS
as said in Oracle Database 11g document http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_spadmn.htm#CACFEJDA
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
Part Number E25788-04
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