ORA-00439: feature not enabled: Deferred Segment Creation on datapump import

Recently I had to downgrade my 11.2.0.1 64bit Enterprise Edition to 11.2.0.1 64 bit Standard Edition.

Since there is no easy way to downgrade, I took an export of all the schema's in data pump format.

When I tried to import the dump into the standard edition, impdp reported the following error on few tables

"ORA-00439: feature not enabled: Deferred Segment Creation on datapump import"

Looks like "Deferred Segment Creation" is available only in Enterprise edition and not in Standard.

There are 2 workarounds

 

Workaround 1

1) Let the import fail, and get the SQL for all the failing tables from the log file. Drop the schema, recreate an empty schema, and create those tables using the SQL above.

2) Add table_exists_Action=append to your parfile

3) Import the dump again

 

Workaround 2

1) This is probably an easier option, Add  Version parameter to your parfile, and specify a lower version.

2) In my case, I added version=11.1, and it worked for me