My Oracle Support Banner

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 AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 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.



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.


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.