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!

Database Link for All users

Kam__apexAug 6 2020 — edited Aug 10 2020

Dear Friends

I have a two servers. (server1 and server2).  In server1 oracle10g is installed and server2 has oracle 18c. In server1 almost 10 users/schemas are created and several tables are created in different schemas. I want to make reports in server2 and some of the data want to fetch from server1 from different schemas. Can you please tell me, can i make one database link for all schemas?

Please help.

Regards

Kam

Comments
Post Details
Added on Aug 6 2020
9 comments
134 views