Re:Describe over DB_link

From: <dgoulet_at_vicr.com>
Date: Thu, 11 Jan 2001 15:39:14 -0500
Message-Id: <10738.126432@fatcity.com>

Johnson,

    You bet, something that came out/in with SQL*Plus ver 8.0 and beyond. You HAVE to specify <owner>.<table_name>@<db_link> no matter if there is a public synonym on the remote or not. One other note, a public synonym on the local node that does not follow the same rules behaves funny too.

Dick Goulet

____________________Reply Separator____________________

Subject: Describe over DB_link
Author: Johnson Poovathummoottil <joni_65_at_yahoo.com> Date: 1/11/2001 11:46 AM

Hi,

Has anyone noticed any special behaviour by Describe when done over a DB_link?

Johnson

---

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnson Poovathummoottil
  INET: joni_65_at_yahoo.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 Thu Jan 11 2001 - 14:39:14 CST