restore.sql

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

	SET ECHO      OFF;
	SET FEEDBACK  OFF;
	SET PAGESIZE  0;
	SET TERMOUT   OFF;
	SET HEADING   OFF;
	SET VERIFY    OFF;
	set trimout   on; 
	SET LINES     200;
	set trimspool on;
	spool drop.sql;
	select 'drop table '||TABLE_NAME||';' as SAL from USER_TABLES where TABLESPACE_NAME is
 				not null ;
        select 'quit;' from dual;

	spool off;
quit