Database Administration (MOSC)

MOSC Banner

How to copy table data into another table

Dear All,

I have a table t1 with 500 000 000 records in it and need to copy t1 into another table t2.

Kindly ask you to tell me which could be more efficient way to this task?

  1. insert into t2 select * from t1;
  2. use expdo/impdp (export t1 and then import it in t2 with append option)

does impdp work more fast than insert statement? or does it use the same techniques as insert statement does?


Thank you all.

Regards,

David

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center