On Aug 16, 7:05 am, Gayathri <gd0...@gmail.com> wrote: > 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- Hide quoted text - > > - Show quoted text -
Why are you using a db link between two schemas in the same database? Normally one uses synonyms to access tables/views/objects owned by another user in the same server. David Fitzjarrell -- 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
