Ramesh_R wrote:It is like saying you want to drink a glass of water.. but without the glass and without the water. It simply does not make sense saying that you want a network connection between database a and b, but a database link (which defines a network connection between databases a and b ) is not to be used.
I have a scenario as i have to connect to a remote oracle DB from my database without creating the database link my database.
user11999337 wrote:Please do not reply to answered 3 year old threads.
I have a similar question in this regard.
Let's say I want to run a query from a database and use data from another database. I have the user, password, SID and port number of the other database but do not want to create a separate connection using sqlplus or connect commands.
Something like this:
SQL> show user
USER is "A"
SQL> select a.col1, b.col2 from tab1 a, tab2@????? where <some condition>;
Can this connection be done on the fly ?? I agree that a DB link will do the trick, but let's say I am not supposed to create objects on the other database.