Oracle Database Discussions

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!

Data migration from one table to another

amrish kothariAug 16 2006 — edited Oct 5 2006

Hello All,

I have to migrate the data from one table to another.
Both the tables have around millions of rows.
I have written one migration script , but it takes around 1 full day to completly run and commit.

Can i know some best ways to migrate .

Thanks and Regards,
Amkotz

Message was edited by:
Amkotz

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2006

Added on Aug 16 2006

#general-database-discussions

4 comments

535 views