OraFAQ Forum: Server Administration » DBMS_METADATA.GET_DDL - How to install? Special privileges? Extract all user schema?

Home » RDBMS Server » Server Administration » DBMS_METADATA.GET_DDL - How to install? Special privileges? Extract all user schema?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_METADATA.GET_DDL - How to install? Special privileges? Extract all user schema? [message #60445]

Sun, 08 February 2004 22:16

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

How to use DBMS_METADATA.GET_DDL to extract not only one table, but the entire schema? Is DBMS_METADATA.GET_DDL "installed" on Oracle 9i or do we need to implement it? Which privileges do one need to use DBMS_METADATA.GET_DDL?

Thank you very much for your answer.

Regards,

Patrick Tahiri.

SQL> select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u;

Report message to a moderator