run.sql

来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 24 行

	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 result.bat;
	

	select 'exp dyt/sql@dytsms rows=no tables=^' as SAL from dual;
	select TABLE_NAME||',^' as SAL from USER_TABLES where TABLESPACE_NAME is
 				null;
	select 'city  file=partition.dmp' from dual;

	select 'pause' from dual;
	spool off;
quit