impdp (no TTS) and deferred segment creation

From: Uwe Küchler <>
Date: Thu, 27 Feb 2014 19:26:31 +0100
Message-ID: <>

Dear oracle-l'ers,

I had my #WTF moment today when I tried to import a dump that was exported with metadata only with the intention to cram this into a much smaller development DB.
Export came from SE and went into EE, where deferred segment creation was enabled. But much to my astonishment, the tablespaces filled up quickly because segments were created and not deferred! To double check, I let impdp generate a DDL file and searched for a "segment creation immediate" clause - there was none.

Checking MOS I could only find a similar behaviour related to TTS (which was discussed here, too:

Any idea what's going on here? What could be done to import with no segments as intended (aside from running the DDL file, which has its own drawbacks)?

Kind regards,


Received on Thu Feb 27 2014 - 19:26:31 CET

Original text of this message