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