RE: impdp (datapump) with nologging?

I should've added - the solution/work-around to this problem is to drop the 
indexes prior to importing, then create them with parallel and nologging after 
the import is complete.  Index creation/rebuild CAN be done with nologging, 
it's only the maintenance (updates/inserts/deletes) on an existing index that 
requires logging.


-----Original Message-----
From: Allen, Brandon 
Sent: Tuesday, August 30, 2005 3:00 PM
To: 'kutrovsky.oracle@xxxxxxxxx'; oracle-l
Subject: RE: impdp (datapump) with nologging?


Do you have indexes on the object(s) you are importing?  As was discussed at 
length on this list last week - index updates are always logged, even if the 
index is CREATE/ALTERed as NOLOGGING.  The documentation indicates otherwise - 
but is incorrect.

Regards,
Brandon


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Christo Kutrovsky
Sent: Tuesday, August 30, 2005 2:50 PM
To: oracle-l
Subject: impdp (datapump) with nologging?


Does anyone know how to do this ?

I tried setting the default of my tablespace to nologging, and the
object was created nologging, but still several GB of redo were
generated.

Any ideas ?

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

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

Other related posts: