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!

Bulk transaction insert single table , (1Lakh and above )

User_BE259Aug 3 2022 — edited Aug 4 2022

My problem is, that there is table A and table B, table A has large data of transaction,
I need to shift all data into table B from table A at EOD and the data volume is 1 lakh to 10 lakh.
so can you please suggest what is the best way to do it in Oracle?

This post has been answered by Jonathan Lewis on Aug 10 2022

Jump to Answer

Added on Aug 3 2022

#general-database-discussions

7 comments

279 views

1 mention