Database Utilities (MOSC)

MOSC Banner

Unable to render DDL for object with DBMS_METADATA attempting internal generator using SQL Developer

edited Dec 6, 2011 7:39AM in Database Utilities (MOSC) 7 commentsAnswered ✓
Trying to export DDL that includes grants from SQL Developer 3.0.04 (Oracle 11gR2).

For all non-DBA users, when they attempt to use the Export wizard to export DDL, they get a message about having to use the internal generator rather than DBMS_METADATA for TABLE DDL, INDEX DDL, TRIGGER DDL, etc. This does not happen for DBA users. Non-DBA users have Select Any Dictionary granted through a role. Attempts to directly grant execute on sys.dbms_metadata didn't change anything.

Has anyone had this issue before? Is this a SQL Developer quirk or some permissions related issue?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center