Hi All,
I had problem creating this DB LINK. in Oracle DB 11g. Here is what i have.
Need to create DBLINK between 2 different schema in same DB instance:
Location of tnsnames : $ORACLE_HOME/network/admin.
*TNSNAMES.ora*
DEVENV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gd0204)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devenv)
)
)
*from user1 schema:(user1/user1):*
CREATE DATABASE LINK link_to_user2 CONNECT TO user2 IDENTIFIED BY user2
USING 'devenv';
*from user2 schema:(user2/user2):*
select * from user_db_links;
no data found.
Not sure what am i missing.
Please help me set up DBlink.
Thanks in advance
G
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
