Re: INSERT with NOLOGGING

I just asked a similar question a few days ago.

I'm not sure which version of Oracle you need, but...

Alter table TableA nologging ;

then

insert /*+ append */ into TableA select * from TableB ;

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!