add_temp_files.sql

来自「Oracle RMAN scripts, windows下Oracle RMAN」· SQL 代码 · 共 27 行

set echo off
	set feedback off
	set newpage none
	set pagesize 0
	set linesize 800
	set verify off
	set pagesize 0
	set trims on
	set linesize 600
	set heading  off
	set timing off
	set verify off
	
	conn / as sysdba
	WHENEVER SQLERROR EXIT 1
	
	exec pro_gen_add_files_to_temp_ts;
	
	prompt
	prompt
	prompt
	
	SELECT   text
	FROM     temp_for_pro_gen_ts_sql_temp
	ORDER BY lineno;
	
	exit 0