Oracle DBA
Useful stuff related to Oracle DBA, Demantra & OTM
Search for your Content
Wednesday, July 6, 2011
Getting DDL
SQL> set long 2000
SQL> set lines 20000
SQL> set pages 10000
SQL> select dbms_metadata.get_ddl('<OBJECT_TYPE>','<OBJECT_NAME>') from dual;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment