Database Administration (MOSC)

MOSC Banner

DBMS_METADATA.GET_DDL

edited Nov 12, 2015 9:07AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hello,

How one can retrieve definition of all objects not in sys schema?

The following for tables is failing:

sql / as sysdba

SQL> SELECT DBMS_METADATA.GET_DDL('TABLE', TABLE_NAME) FROM dba_tables  where owner not in ('SYS');

ERROR:

ORA-31603: object "OL$" of type TABLE not found in schema "SYS"

ORA-06512: at "SYS.DBMS_METADATA", line 4018

ORA-06512: at "SYS.DBMS_METADATA", line 5843

ORA-06512: at line 1

Thank You

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center