RE: [EXT] impdp (no TTS) and deferred segment creation

From: Uwe Küchler <>
Date: Fri, 28 Feb 2014 15:22:46 +0100
Message-ID: <>

Tao and Raj,

thank you for this hint! Now it worked the way I expected impdp to work in the first place.
Although, "TRANSFORM=STORAGE:n:table" would be the better option in my case as I don't want the tablespace clauses omitted.

However, I still find the behaviour contradictory and inconsistent: - Running impdp without a TRANSFORM command and deferred_segment_creation=TRUE does *not* defer segment creation. - Running impdp without a TRANSFORM command and spooling into a SQLFILE yields no segment creation clause in the CREATE TABLE statements.

So, at least one of the two modes does not work as expected. Or am I missing something here?

Kind regards,

Am Do, 27.02.2014, 19:50, schrieb Wang, Tao:
> When using impdp, try to use " TRANSFORM=SEGMENT_ATTRIBUTES:n " ...
> Hope it helps.
> Thanks,
> Tao
> -----Original Message-----
> From: []
> On Behalf Of "Uwe Küchler"
> Sent: Thursday, February 27, 2014 1:27 PM
> To: oracle-l
> Subject: [EXT] impdp (no TTS) and deferred segment creation
> 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.

Received on Fri Feb 28 2014 - 15:22:46 CET

Original text of this message