とあるユーザのテーブル定義をひっこ抜くSQL (for Oracle)

create_ddl.sql

-- [実行方法]
--   sqlplus scott/tiger@localhost:1521/sid @create_ddl.sql
-- [出力結果]
--   create_table.sql
-- [参考]
--   http://oracle.se-free.com/ddl/A1_get_ddl.html

set long 2000
set heading off
set line 120
set pages 2000
set long 2000
set heading off
set trimspool off
set feedback off
set longchunksize 600

EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(
DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',TRUE)

spool create_table.sql

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

spool off;

exit;