Re: Problem in DB Link

From: Gillian M <zmkj04_at_yahoo.com>
Date: Mon, 2 Oct 2000 15:32:13 -0700 (PDT)
Message-Id: <10637.118353@fatcity.com>

Make sure the userid and password is valid on the database that you want to link to. Try connecting to the database outside of the link, using that same userid and password.

Then you must have access to all the tables within that nest.

G!
--- ramakrishna.gv_at_db.com wrote: > Hi
> If global_names parameter is true in ur init.ora
> file then the database link name should be the name
> of the other database.
> Check the above parameter and database link.
>
>
>
>
> Thanks & Regards
> ----------------------------
> Ram
> Tel:4236953
>
>
> ---------------------------------------- Message
> History ----------------------------------------
>
>
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: ORACLE-L_at_fatcity.com
> cc:
>
>
>
>
> Dear List,
> I have created a DB link on an Oracle database
> to another. Both
> on Oracle 8. The link was created without error. but
> whenI try to
> select some values using this I get an error saying
> invalid user id
> and passowrd, though whatever was given in the link
> was correct. Can
> anybody tell me why this happens,. Also is it
> possible to select
> values from tables with nested tables using the db
> link..
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: prem_at_ibsplc.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

---

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: ramakrishna.gv_at_db.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

---

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).

---

Received on Mon Oct 02 2000 - 17:32:13 CDT