Skip to Main Content

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!

fast way to export and import a big table

ANNECJun 15 2022

I am using oracle 19c and oracle sql developer.
What is the best and fast way to export records in a table with a million records, and imported into another table with same name that existed in another database on another server?
for example export from a prod environment to a dev environment?
in this case I only want the single table, not other tables or database.
Thanks

This post has been answered by cormaco on Jun 16 2022
Jump to Answer
Comments
Post Details
Added on Jun 15 2022
3 comments
3,831 views