How to pre-create or materialize segments on 11g for existing tables (Doc ID 1482692.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Goal

 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

Solution

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