获取表空间和用户的DDL语句
spool get_ddl_info.logset pagesize 0set linesize 1000 set feedback off set long 999999 set pagesize 1000 set heading offprompt select dbms_metadata.get_ddl('TABLESPACE',TS.tablespace_name) from DBA_TABLESPACES TS;select dbms_metadata.get_ddl('TABLESPACE',TS.tablespace_name) from DBA_TABLESPACES TS;prompt select dbms_metadata.get_ddl('USER',U.username) from DBA_USERS U;select dbms_metadata.get_ddl('USER',U.username) from DBA_USERS U;prompt select username from dba_users;select username from dba_users;spool off
?
?
