Home » SQL & PL/SQL » Client Tools » Alternate solution to DB link (oracle 9i)
Alternate solution to DB link [message #547440] Wed, 14 March 2012 05:47 Go to next message
shail ra
Messages: 4
Registered: February 2012
Junior Member
Hi ,

I need to remove db link from the existing system .But problem is if we remove the Db link then how come we can access the remote db's data.

Is there any effective way to select the data from remote db. without using dblink.

can you please also suggest why there is a need to remove db links .
Re: Alternate solution to DB link [message #547445 is a reply to message #547440] Wed, 14 March 2012 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59775
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any effective way to select the data from remote db. without using dblink


No.

Quote:
can you please also suggest why there is a need to remove db links .


There is a need to remove a db link when it is not used.

Regards
Michel
Re: Alternate solution to DB link [message #547448 is a reply to message #547445] Wed, 14 March 2012 06:02 Go to previous messageGo to next message
shail ra
Messages: 4
Registered: February 2012
Junior Member

Michel

Thanks for quick reply .

I have a requirement like that and in that they want to remove all the db link .and asked for alternative solution.
Re: Alternate solution to DB link [message #547457 is a reply to message #547448] Wed, 14 March 2012 06:16 Go to previous messageGo to next message
cookiemonster
Messages: 11191
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why do they want to get rid of the DB links?
Maybe they think there is a problem with them that doesn't exist.

EDIT: typo

[Updated on: Wed, 14 March 2012 06:16]

Report message to a moderator

Re: Alternate solution to DB link [message #547483 is a reply to message #547448] Wed, 14 March 2012 07:21 Go to previous message
Michel Cadot
Messages: 59775
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
and asked for alternative solution


As I said there is none (inside Oracle).
If you want to get rid of db links then you have to program multiple connections in your program and handle 2 phase commit.

Regards
Michel
Previous Topic: Script to compare two schemas from different instance of DB
Next Topic: Output of a DB Query as Email using Powershell
Goto Forum:
  


Current Time: Tue Nov 25 23:39:55 CST 2014

Total time taken to generate the page: 0.08529 seconds