Re: How to open a cursor for the results of describe?

Thanks Noel,

I didn't know about the view ALL_SYNONYMS. It will be useful. However, it does not help me to find out more about the structure of the table behind the DBLINK, does it? As far as I can see, I would have to log in to the remote server and search its system views for the Schema and Tabel name found in ALL_SYNONYMS. Or am I missing something?

Roel

Noel <tbal_at_go2.pll-l> wrote in message news:<d13ubt$c0n$1_at_inews.gazeta.pl>...
> Użytkownik Roel Schreurs napisał:
>
> > Hi All,
> >
> > DESCRIBE <synonym>, using Toad, the column structure shows up nicely.
>
> Remember, that synonym is a pointer to object, and have no structure itself.
> Look at ALL_SYNONYMS view, in column TABLE_NAME you get object name
> which is pointed by synonym.
Received on Tue Mar 15 2005 - 13:50:51 CST