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

Thread: Alternative to Database Link

  1. #1
    Join Date
    Feb 2003
    Posts
    24

    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I prefer synonyms because you can alias packages & procedures as well.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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