Monday, January 30, 2012

Get DDL for tables in Oracle

1. Use dbms_metadata
select dbms_metadata.get_ddl('TABLE','TEST','SCHEMA') from dual;
2. Using exp/imp
exp user/password file=dump.dmp tables=table1,table2 rows=n
imp user/password file=dump.dmp tables=table1,table2 show=y
3. Using DDL Wizard
www.ddlwizard.com

No comments:

Post a Comment