How to connect to remote database without using DBlink?

[suhaimi]

Hi all,
How to connect to remote database without using DBlink? I've read somewhere over the internet that it's possible to do this. I forgot the website. It did say about truss/trusted connection.
Any input????

Rgds,
Suhaimi

 

[SantaMufasa]

Suhaimi,

What is your objective? If your only restriction is "to connect to a remote database without using DBLink", we do that all the time using the Oracle client and connecting, for example, "sqlplus <username>/<password>@<tns-alias>. So, to offer a meaningful response, we need to know what you are trying to do and under what restrictions.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:44 (27Sep04) UTC (aka "GMT" and "Zulu"), 23:44 (26Sep04) Mountain Time)

 

[suhaimi]

Hi,
Sorry for the confusion. What I meant was querying from remote database located in different machine. For example:
sqlplus xuser/xuser@DB_ONE
sqlplus>select count(*) from xuser.mytable@DB_TWO;

From local instance DB_ONE, I would like to query info from remote database DB_TWO without creating DBlink. I've read this somewhere, we could do it using trusted connection or truss if I'm not mistaken.

Rgds,
Suhaimi

 

[SantaMufasa]

Sorry, Suhaimi, I'm not familiar with the method to which you refer. DBLinks have always given me magnificent service, so I just use them for my remote access needs.

Mufasa
(aka Dave of Sandy, Utah, USA @ 02:34 (28Sep04) UTC (aka "GMT" and "Zulu"), 19:34 (27Sep04) Mountain Time)

 

[sem]

You should definitely find that "somewhere", because I've also never read about other than creating db link way to connect from one Oracle instance to another one. Most probably you should also forget about that place as well as about any information obtained from that source

Regards, Dima

http://seminihin.narod.ru