set heading off set echo off set feedback off set pages 10000 spool stop_index_monitor.sql select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u; spool off set heading on set echo on set feedback on
SQL> select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u; 就像楼上所写的,但要设置输出宽度
set echo off
set feedback off
set pages 10000
spool stop_index_monitor.sql
select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u;
spool off
set heading on
set echo on
set feedback on
就像楼上所写的,但要设置输出宽度
http://www.cnoug.org/bin/ut/topic_show.cgi?id=2451&bpg=1&age=0