Skip to Main Content

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!

Move data from one DB to another DB using DB link where I had LOB columns as well.

User_JZ8QAApr 19 2020 — edited Apr 19 2020

Hello Guru,

I want to transfer multiple tables data from one Database to another database using db_link, since Database is hosted on another vendor, Hence without using datapump or exp etc., through DB link need to move tables data from one source DB to another source DB where the tables are having LOB columns as well, Hence we could not able to use insert into as select * from@db_link;

Kindly suggest what are all the best ways to move tables data between DB using db links etc., .

Kindly share syntax / step by step how to proceed for the above.

Thanks in Advance,

Sivakumar KS.

Comments
Post Details
Added on Apr 19 2020
5 comments
2,030 views