Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need PL/SQL suggestion
Yes it is -
alter table XXX nologging;
insert /*+ append */ into XXX select cols from elsewhere;
No rollback, no redo (if there are no indices) Nominally as fast as sql*load direct load. Needs a commit afterwards.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Greg Akins wrote in message <04608828.422d05cc_at_usw-ex0108-059.remarq.com>...
>Oracle 8.0.5
>
>I have already included the dbms_sql truncate... And I
>drop the indexes before performing the insert.
>
>I take it the nologging isn't available in 8.0.5? Any
>other way to replicate the speed of an SQL*Plus 'Copy'
>
>-greg
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Oct 05 1999 - 14:30:12 CDT