-
Alternative to Database Link
Hi all,
I need your expertise in database link.
The issue is:
I have 2 databases in different server. Database A is in server A, and database B in server B.
What is the best way to see all the tables in database B in server B, from server A?
I can't move and migrate the data from server B to server A.
What way will you suggest to achieve this?
Can i create a view in server A through a database link for all the tables in database B?
Thank you for your comments. I really need your expertise suggestion on this.
Performance is the main issue.
Thanks
Robby
-
Re: Alternative to Database Link
Yes, why not. Create the views (using DB link).
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
I prefer synonyms because you can alias packages & procedures as well.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|