set pagesize 0
spool c:\tb.sql
select 'desc '||table_name from cat where table_type=upper('table');
spool off;
spool c:\tbcol.sql
@c:\tb.sql
spool off;
spool c:\tb.sql
select 'desc '||table_name from cat where table_type=upper('table');
spool off;
spool c:\tbcol.sql
@c:\tb.sql
spool off;
SQL>select * from USER_TAB_COLUMNS;
SQL>spool off;导出的文件就在c:\a.sql里
SQL>select * from USER_TAB_COLUMNS;
SQL>spool off;导出的文件就在c:\a.sql里