DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Link alternatives

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Posts
    335

    Database Link alternatives

    Whilst logged into database A, can you, without using a database link, look at data in a table on database b?

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    Do you have any problems with DB links ??
    Raghu

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    no other way

    what Oracle version???

  4. #4
    Join Date
    Jul 2002
    Posts
    335
    Versions 817 and 920.

    Its not that we have problem with the links, its just that we ahve a very large environment, some systems have been inherited and we have dozens of links hanging about, some are used, some aren't, and we want to the creation of new ones kept to a minimum.

    Is there no other way, the documentation suggests not.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, create a java stored procedure that connects via JDBC to your remote database.
    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
  •  


Click Here to Expand Forum to Full Width