OracleConnections

Oracle Community Network

How to get the definition for a view only accessable via synonym in an Oracle database?

Is there any way to get the type or general table/view definition from an Oracle database synonym? Are special rights neccessary to get it or is it even impossible and I have to check the real source database? I am especially interested in the column datatypes and length of the type (where it matters).

Thanks a lot in davance.

4 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Christy Yolanda on May 2, 2013 at 11:06am

It depends... are you able to query the view/table without the synonym?

SQL*Plus command DESC[RIBE] works with synonyms.

▶ Reply

Permalink Reply by Kenzie Rita on May 2, 2013 at 11:21am

To create a private synonym in your own schema, you must have the CREATE SYNONYM system privilege.

To create a private synonym in another user's schema, you must have the CREATE ANY SYNONYM system privilege.

To create a PUBLIC synonym, you must have the CREATE PUBLIC SYNONYM system privilege.

▶ Reply

Permalink Reply by Amy Andrea on May 2, 2013 at 11:24am

The synonyms are especially important when users who don't own objects need to access the database using an application with embedded SQL (discussed in Chapter 15). The programming effort to make such applications work properly without synonyms would increase tremendously.