SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy 500 million records between 2 tables

608271Nov 13 2007 — edited Nov 14 2007

Hi,

I have 2 tables T1 and T2 in the same database and schema as well.

But the Size of data in T1 is around 500 million. Which is the best way to Copy data from T1 to T2.

How fast is the SQL PLUS Copy Command?

Will BULK COLLECT into collection and FOR ALL statements help in doing the job at high speeds?

Are there any other options?(I only want to use SQL PLUS or PL/SQL)

please let me know if there is a way out.

Thanks,
Vijay

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2007

Added on Nov 13 2007

29 comments

12,896 views