RE: Describe over DB

From: David Barbour <dbarbour_at_connectsouth.com>
Date: Mon, 15 Jan 2001 10:39:32 -0600
Message-Id: <10742.126688@fatcity.com>

Joni,

We've got 8.05 and 8.1.6 DBs and you can get describe to work w/o using the schema name by creating a public synonym for the table on the target DB and granting select on the table to the username in the DB Link.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Johnson Poovathummoottil [mailto:joni_65_at_yahoo.com] Sent: Monday, January 15, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Describe over DB_link

We have only 8.1.6 databases. while Describing across db_links without schema name we get 'table or view does not exit'. But if we include the schema name it works. But if a table with the same name exists in the current schema, it describes the table in the current schema and not the one in the db_link.

"Hately, Mike" <Mike.Hately_at_Derwent.co.uk> wrote:
> There is all sorts of "special behaviour" with
> DESCRIBE over a DB link.
> Bugs, restrictions, pitfalls. What are your database
> versions and error
> messages/symptoms/observations?
>
> Regards, Mike Hately, DBA

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.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 Mon Jan 15 2001 - 10:39:32 CST