oracle中获取表空间ddl语句[2]

set serveroutput on size 1000000;
set heading off;
set feedback off;
set echo off;

spool /ora_backup/orasysbak/bill_tabspace_ddl.sql
select ddl_txt from bak_dba_tablesapce;
spool off;
exit
!
if [ $? -ne 0 ];then
echo "error! generate tabspace ddl failed! please check it"
#mail ...
exit 1
fi