In 11gR2 Skips The Table At Full And Schema Level Export Or Shows EXP-00011 At Table Level Export (Doc ID 1178343.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.
This Note is applicable only when the parameter DEFERRED_SEGMENT_CREATION=TRUE.

Symptoms

Using DEFERRED_SEGMENT_CREATION=TRUE

The new feature for the space allocation method in 11gR2 causes the export utility to skip the table in case of full or schema level exports. Using a table level export it displays "EXP-00011: 'Table Name' does not exist" in the export log.
 

Changes

This Note is applicable only when the parameter "DEFERRED_SEGMENT_CREATION=TRUE".

By default the value of DEFERRED_SEGMENT_CREATION is TRUE. If a user sets this parameter to FALSE then the instance has to be bounced, but this will not effect the existing tables.  New tables that the user creates will have the impact of this changed parameter setting.


Cause

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