Re: AW: datapump and deferred_segment_creation

Hi Ahmed,

"ahmed.fikri_at_t-online.de" <ahmed.fikri_at_t-online.de> writes:

> So the question, is there any reason or other use case behind
> the choice of the default value of this parameter, or maybe the
> default values are generally chosen haphazardly?
>
> And why oracle introduces this parameter in datapump, which
> overrides the system parameter deferred_segment_creation, even
> the last one can be changed at session level? (one can use
> loggon trigger for datapump outside pl/sql)

You still haven't provided any details as to how and what you are really doing. Things like database versions and details of the source and target expdp/impdp may matter.

For example:

Deferred_segment_creation Behavior When Importing in 11g a Dump Created in 10g (Doc ID 1637985.1)

or, was deferred_segment_creation = true set on the database during the expdp?

Thanks,

Andy K

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