Re: COPY vs. INSERT

From: Serge Kosourikhin <kosour_at_braz.ru>
Date: Wed, 24 May 2000 09:56:45 +0900
Message-Id: <10506.106452@fatcity.com>

• Original Message ----- From: <Winnie_Liu_at_infonet.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 24, 2000 10:15 AM Subject: Re: COPY vs. INSERT

>
> COPY is a SQLPLUS command only while INSERT is a SQL command that can run
> anywhere (not restrict only to SQL PLUS)
> you can set SQLPLUS in a way that they will commit after certain number of
> rows are COPied to the table, while without doing any PL/SQL script, you
> can only commit once after the whole insert goes through.
>
> That means, COPY will not eat up rollback segment the way INSERT is (if
> rollback space is a concern to you)
>
> And COPY had a lot of options like REPLACE, APPEND, INSERT, TRUNCATE(I
> believe!) etc. but INSERT will only add to the end of the table.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I suppose, to blocks from free list, not to end of the table (of course, if there isn't hint "APPEND")

Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant Received on Tue May 23 2000 - 19:56:45 CDT