No records when using SELECT query on DBLINK in Oracle

3.6k views Asked by At

I'm trying to move data in between two oracle databases say SOURCE_A and DEST_B. I have created a dblink (LINK_A) using TOAD on DEST_B to SOURCE_A to copy data from the tables. Dblink creation was fine, but when I used a select statement like below, I see no data except column names.

SELECT * FROM TABLE_A@LINK_A;

Could you please help me understand what am I doing wrong or missing here. I tried running a DESC on the TABLE_A using the link and it worked fine. Not sure why its not pulling any data from the SOURCE_A database.

Any help is greatly appreciated. Thanks.

1

There are 1 answers

0
Sirish On BEST ANSWER

Alright, with many trial and errors, I managed to get a solution that works for me in this SO question.

I used the technique provided by - Jeremy Scoggins and it worked like charm. I was able to move data using toad and its perfect. Thanks to all of you for your time and support.

Appreciate it.