In 11gR2 Skips The Table At Full And Schema Level Export Or Shows EXP-00011 At Table Level Export
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11.0
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.
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.
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