Re: SQL*PLUS: Copy table or INSERT INTO table@remotedb?

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 - 13:57:22 CST