-- 获取创建表空间的ddl语句 set long 2000000000 echo off feedback off heading off pagesize 0 linesize 30000 trimout on wrap on trimspool on termout off serveroutput off SQLPROMPT "SQL>" col ddl for a3000 wrapped word execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'STORAGE',false); execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'PRETTY',true); execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true); spool ctbs_create.sql select dbms_metadata.get_ddl('TABLESPACE','LUCIFER') ddl FROM dual; spool off