Because database links are public, private or shared. If it were a public
one, you could do a desc without that error. If it had it a public synonym,
you could issue a desc of the synonym without that error. The shared ones
are available when you use MTS. Then connect as the user who created it or
create a synonym and issue the desc.
> -----Mensaje original-----
> De: Johnson Poovathummoottil [SMTP:joni_65_at_yahoo.com]
> Enviado el: lunes 15 de enero de 2001 14:41
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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 - 09:27:44 CST
