Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

grant needed for dbms_metadata.get_ddl on objects in another schema

dario-2280378May 2 2011 — edited Sep 3 2013
In Oracle 11g R2, I use dbms_metadata.get_ddl to get DDL from another schema, but I got an error:

ORA-31603: object "IS_SNMP_DATA" of type TABLE not found in schema "TXV"

which grant is needed for this package to get ddl from another schema?
I tried with authid current_user (as I found on google), but no result...
This post has been answered by Kamran Agayev A. on May 2 2011
Jump to Answer

Comments

Jan
Not experienced with the windows implementation, only on linux ... but maybe it may help ...
cx_Oracle is only the bridge between python and the oci interfaces of Oracle, an exposure of the c-api's towards python.
On linux you must set the LD_LIBRARY_PATH variable to the location where the oracle client libraries can be found. (typically something linke libclntsh.so.*). So ... I guess that on a windows environment the client dll's should be in the path (%PATH%) ... Hope somebody can confirm or correct this. Maybe it may help ...
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 1 2013
Added on May 2 2011
#general-database-discussions, #schema
20 comments
31,094 views