Re: impdp (datapump) with nologging?

  • From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
  • To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • Date: Tue, 30 Aug 2005 18:15:23 -0400

I am using datapump import (impdp) with a non-existing table. i.e.
impdp is creating the table. Same with the indexes and they seem to be
created after importing the table data.

So I dont think this is the case here.

On 8/30/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
> 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
> --
> //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.
> 
> 


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

Other related posts: