SQL*PLUS: Copy table or INSERT INTO table_at_remotedb?

[Quoted] 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:45:30 CET