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