Alternative to Database Link Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Alternative to Database Link

  1. #1
    Join Date
    Feb 2003

    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.


  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland

    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

  3. #3
    Join Date
    Nov 2000
    I prefer synonyms because you can alias packages & procedures as well.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width