lookspace.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

	SET ECHO      OFF;
	SET FEEDBACK  OFF;
	SET VERIFY    OFF;
	SET PAGESIZE  0;
	SET TERMOUT   ON;
	SET HEADING   OFF;
	spool result.sql;
	
        select 'SET ECHO      ON;' from dual;

select 'create tablespace ',f.tablespace_name,
' datafile ' ||f.FILE_NAME||' SIZE '||BYTES/1024/1024||'M REUSE',
' DEFAULT STORAGE (INITIAL '||INITIAL_EXTENT/1024||'K NEXT '||NEXT_EXTENT/1024
||'K MaxEXTENTS '||Max_EXTENTS||' MinEXTENTS '||Min_EXTENTS||' PCTINCREASE '||PCT_INCREASE ||');'
from sys.dba_data_files f,dba_tablespaces ts where f.tablespace_name=ts.tablespace_name
order by f.FILE_id;
	select 'quit;' from dual;
	spool off;
quit