Re: [EXT] impdp (no TTS) and deferred segment creation
- From: "Uwe Küchler" <uwe@xxxxxxxxxxxx>
- To: andy@xxxxxxxxxxxxxxx
- Date: Fri, 28 Feb 2014 18:52:58 +0100
Andy,
> The deferred_segment_creation parameter won't have an effect on the import.
> This session/system parameter is superseded by the actual table attributes.
OK. But wouldn't it be consistent, then, if the actual table attributes
were also spooled out to the SQLFILE (identical command line arguments
provided)?
> - Running impdp without a TRANSFORM command and spooling into a SQLFILE
>> yields no segment creation clause in the CREATE TABLE statements.
>>
>>
> To do this, then use: TRANSFORM=SEGMENT_CREATION=n
I think you misunderstood me. If I do NOT provide any transformation
arguments, then the correct segment creation clause should be in the
SQLFILE. But there is no such clause. IMHO, if the import does create
segments immediately, there should as well be a "segment creation
immediate" clause in the sqlfile. But there isn't.
Have a nice weekend,
Uwe
--
//www.freelists.org/webpage/oracle-l
Other related posts:
