Sorry My mistake: I was checking it from the wrong schema.
On Tue, Aug 16, 2011 at 6:57 AM, Gayathri <gd0...@gmail.com> wrote: > 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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
