Help!

[gieboy]

I had 2 Database Pro1(sid = pro1) and Pro2(sid = pro2). Pro1 is residing on a different machine. I need to make an sql script to get data from pro2, the script will run on the machine where pro1 resides using sqlplus. How can I connect to Pro2? Both machine are running on unix.

 

[alexhu]

sqlplus user/passwd@pro2

you need to change tnsnames.ora on the first server to show the host of pro2.

Alex

 

[THoey]

You can also create a database link between the two databases... Terry M. Hoey

 

[gieboy]

Thanks to both of you, that was very helpful