|
-
You have to create the link so:
create database link el_sur
connect to usuario identified by clave
using 'El450Sur';
usuario is the user;
clave is the password
el_sur is the link's name.
---
Then in $ORACLE_HOME/network/admin/tnsnames.ora
add it
El450 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= enel02)(Port= 1521))
(CONNECT_DATA = (SID = conv))
)
enel02 is the name of the remote machine, conv is de database name.
---
Now you can do it:
select * from your_table@el_sur;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|