Re: Need PL/SQL suggestion

Which version of Oracle ?

1. Don't do a delete, use dbms_sql or dbms_util.execute_ddl_statement to do a truncate (I may have wrong name for the execute_ddl)
2. If running 8.1 then insert /*+ append */ into a nologging table. But after a truncate the 'insert into here select from there' should be faster.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Greg Akins wrote in message <05043480.94cc796f_at_usw-ex0108-057.remarq.com>...
>My company had a stored procedure which did simply:
>
>begin
> delete from members ;
> insert into members (select * from members_at_dblink2) ;
>end ;
>
Received on Tue Oct 05 1999 - 12:50:36 CDT