Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cloning 21 GB Table - Review Approach please

Re: Cloning 21 GB Table - Review Approach please

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 11 Mar 2005 14:27:25 -0500
Message-ID: <015201c5267e$779893f0$54d58640@porgand>


Hi,

I think nologging as a hint worked in 9.2.0.4 and 10.1.0.2 versions, but it was undocumented. Maybe they've removed it again in later versions... If you have access to 9.2.0.4, you could test out...

Tanel.

>> /*+ nologging */ -- I haven't seen that as
>> a hint, and it doesn't seem to do anything on
>> my 9.2.0.6 system.
>
> My mistake! No such hint, going all the way back to 8.0.4 (which is
> pretty
> much when INSERT APPEND came into being).
>
> My apologies to all...
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 11 2005 - 16:45:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US