rem
rem $Header: /s/rw/994/spam/precious/files/ACTIVE/or25up.sql,v 1.1 1998/11/03 04:35:14 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  or25up.sql - Update Oracle Reports schema from v2.0.x to v2.5.2
rem               by calling each upgrade script in turn.  This is somewhat
rem               laborious, but is non-destructive.

spool %ORACLE_HOME%\d2ktab\report30\or25up.log
prompt
prompt Log spooled in ORACLE_HOME\d2ktab\report30\or25up.log
prompt
prompt You must re-grant access to the Oracle Reports tables after running
prompt this script.
prompt
prompt ORA-1430 (Column already exists) and ORA-955 (Name already in use)
prompt errors may occur while running this script and are acceptable.
prompt
 
prompt Running the upgrade scripts...
prompt
prompt running srw20100.sql... 
prompt
start %ORACLE_HOME%\d2ktab\report30\srw20100.SQL 
prompt
prompt running srw20110.sql... 
prompt
start %ORACLE_HOME%\d2ktab\report30\srw20110.SQL 
prompt
prompt running srw20130.sql... 
prompt
start %ORACLE_HOME%\d2ktab\report30\srw20130.SQL 
prompt
prompt running srw20140.sql... 
prompt
start %ORACLE_HOME%\d2ktab\report30\srw20140.SQL 
prompt
prompt running srw2500.sql... 
prompt
start %ORACLE_HOME%\d2ktab\report30\srw2500.SQL 

spool off
