Feb 252014
 Posted by on February 25, 2014 at 7:23 am Database, Oracle Database Tagged with: , ,  Add comments
Oracle Database

While importing a db dump to oracle database we usually get the “Deferred Segment Creation” error while importing. Though the import will continue till end but it fails as a whole import as the import data is corrupt.

This usually happens when you export a dump from higher version of Oracle and trying to import into a lower version of oracle DB.

Error Seen in logs :

ORA-39083: Object type TABLE:""."" failed to create with error:
ORA-00439: feature not enabled: Deferred Segment Creation

In Oracle version 11.2 there is a new feature called “Deferred Segment Creation”. It is a space saver for tables that has no rows since the segments for the table will not be created until the tables gets the rows in it.

We can make it work using a work around of forcing the tables to be created without this feature with impdp command. This can be done by adding “version=” at the end of the impdp command.


impdp [email protected] schemas=SCHEMA_NAME directory=imp_dir dumpfile=DUMP_FILE_NAME.DMP logfile=Import.log version=11.1


© Incase of any copyright infringements please check copyrights page for faster resolutions.

  2 Responses to “ORA-00439 feature not enabled deferred segment creation”

  1. Thanks Rama.. its worked

Leave a Reply

Show Buttons
Hide Buttons