Are you sure your dblinks work?
Check what you have in sys.link$.
If your dblinks are public be sure to create them with the "USING" clause.
Last but not least, you may be hitting a bug.
HTH
SAlu2
Mario Alberto Ramos
>>> [EMAIL PROTECTED] 11/09/01 12:10 >>>
hi list,
i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5,
but its failing,
giving message "DB LINK NOT ACTIVE"
global_names parameter is false on both the database,
the schema in which its being created exists in both the databases with
same password and privillages, and i am using CONNECTED USER mode of
database link,
is that possible to create db link in such conditions,
any suggestions,
Thanks in Advance
Arslan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario Alberto Ramos Arellano
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
