Re: SQL*PLUS: Copy table or INSERT INTO table_at_remotedb?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Nov 2000 20:57:22 +0100
Message-ID: <906bph$46cq$3_at_ID-62141.news.dfncis.de>
Date: Thu, 30 Nov 2000 20:57:22 +0100
Message-ID: <906bph$46cq$3_at_ID-62141.news.dfncis.de>
copy allows you to commit every n rows
(set copycommit n before you start the transaction)
Otherwise your insert is going to be one transaction.
With 300.000 rows this is probably not desirable.
Hth,
Sybrand Bakker, Oracle DBA
"Antonio Sant" <asant_at_iol.it> wrote in message
news:u7yV5.3315$hk4.91643_at_news.infostrada.it...
> Hi there!
>
> Only a quick question:
>
> What is better?
>
> I have to copy a table (300.000 rows) from a local DB to a remote one, I'm
> wondering which is faster or better (ie. less cpu stress, less log
> activity...)
>
> The idea is:
>
> - Log in the remote db
> - truncate table
> - insert or (sqlplus)copy the table
>
> Can you help me?
>
> Thanks!
>
>
Received on Thu Nov 30 2000 - 20:57:22 CET