Thank you all.
Andrew
DA Morgan wrote:
> andyho99_at_yahoo.com wrote:
> > Hi,
> >
> > I'm trying to create a database link at test database. In another word,
> > I'd like to access DEVL database tables from TEST database.
> >
> > I used TOAD to create db link (devl) from TEST database. However, I got
> > the following error messages:
> >
> > Link : "devl"
> > Error : ORA-12154: TNS:could not resolve service name
> >
> > I created db link long time ago without problem. I was wondering
> > whether this error message means some definitions missing in
> > tnsnames.ora. Thanks for your help.
> >
> > Andrew.
>
> You need a valid TNSNAMES.ORA entry for DEVL on the TEST server in
> $ORACLE_HOME/network/admin.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sun Oct 29 2006 - 13:39:43 CST
