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

  • From: Andy Klock <andy@xxxxxxxxxxxxxxx>
  • To: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • Date: Fri, 28 Feb 2014 13:52:14 -0500

On Fri, Feb 28, 2014 at 12:52 PM, "Uwe Küchler" <uwe@xxxxxxxxxxxx> wrote:

>
>  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.
>
>
Ah, probably misunderstanding. I do that. It actually should, I agree, but
you exported from an Standard Edition database which doesn't support
deferred segment creation, so that is probably why it is missing.

There is some weird language in the doc that is slightly ambiguous:

"SEGMENT_CREATION - If set to y (the default), then this transform causes
the SQL SEGMENT CREATION clause to be added to the CREATE TABLE statement.
That is, the CREATE TABLE statement will explicitly say either SEGMENT
CREATION DEFERRED or SEGMENT CREATION IMMEDIATE. If the value is n, then the
 SEGMENT CREATION clause is omitted from the CREATE TABLE statement. Set
this parameter to n to use the default segment creation attributes for the
table(s) being loaded. (This functionality is available starting with
Oracle Database 11g release 2 (11.2.0.2).)"

Meaning, you can't change a "SEGMENT CREATION IMMEDIATE" to be"SEGMENT
CREATION DEFERRED" with this parameter since it is getting this from the
source.  However, using TRANSFORM=SEGMENT_CREATION:n  will cause it to be
omitted completely from the import and then you may get some mileage from
your deferred_segment_creation=TRUE setting.

Have a good weekend too!

Andy K

Other related posts: