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

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,
Uwe

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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> 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 11.2.0.3 SE and went into 11.2.0.3 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.

--
http://www.freelists.org/webpage/oracle-l