create文出力

set long 32000
set pagesize 15000
set linesize 1000
set trimspool on
spool c:\temp\table.sql
select dbms_metadata.get_ddl('TABLE', a.table_name, a.owner) || ';' 
from dba_all_tables a where a.owner='XXXXX';
spool off