SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obtaining columns for tables from synonym, dblink,...

276321Dec 9 2004 — edited Dec 10 2004

In my shema there are a lot of tables and synonyms pointing to tables (or synonyms) in other schemas or tables (or synonyms) over a database link ...

I have to get the structure (column_name, datatype, ...) of the original table, regardless of where is located.

Is there any native mechanism or any available procedure/package to deal with this problem?

Regards,
SaÅ¡o Celarc

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2005

Added on Dec 9 2004

5 comments

1,000 views