Introduction 
~~~~~~~~~~~~ 
  This note is a purely a list of the scripts to run moving between  
  Oracle 8 versions only. It is intended to be a quick reference 
  guide to script names only. 
 
  It is important to read the current Oracle8 Server Migration Guide. 
  Also, further important information is available in README.DOC and  
  READMEMIG.DOC files supplied with the Oracle release that you wish to  
  upgrade to. READMEMIG.DOC is not present for an Oracle 8i installation,  
  only Oracle 8 versions. 
 
Important 
~~~~~~~~~ 
  Before upgrading or changing <Parameter:COMPATIBLE> it is advisable to: 
 
	o Make sure there are no PENDING transactions; 
	o Shut down the database cleanly; 
	o Take a full cold backup; 
 
 
Upgrade Scripts 
~~~~~~~~~~~~~~~ 
 
	  Upgrading         
	From   	To      Script to Run  
	~~~~~~~	~~~~~~ 	~~~~~~~~~~~~~  
	8.0.3   8.0.4	CAT8004.SQL 
        8.0.3   8.0.5   u0800030.SQL 
        8.0.3   8.0.6   u0800030.SQL 
        8.0.3   8.1.5   u0800030.SQL ** See #1 below 
        8.0.3   8.1.6   u0800030.SQL ** See #1 below 
        8.0.3   8.1.7   u0800030.SQL 
 
        8.0.4   8.0.5   u0800040.SQL 
        8.0.4   8.0.6   u0800040.SQL 
        8.0.4   8.1.5   u0800040.SQL 
        8.0.4   8.1.6   u0800040.SQL 
        8.0.4   8.1.7   u0800040.SQL 
  
        8.0.5   8.0.6   u0800050.SQL 
        8.0.5   8.1.5   u0800050.SQL 
        8.0.5   8.1.6   u0800050.SQL 
        8.0.5   8.1.7   u0800050.SQL 
 
        8.0.6   8.1.5   u0800050.SQL ** See #2 below 
        8.0.6   8.1.6   u0800060.SQL 
        8.0.6   8.1.7   u0800060.SQL 
 
        8.1.5   8.1.6   u0801050.SQL ** See #3 below 
        8.1.5   8.1.7   u0801050.SQL 
 
        8.1.6   8.1.7   u0801060.SQL 
 
  #1 On AIX upgrade to a higher 8.0 release and then upgrade to 8.1.5 
     Eg: Upgrade to 8.0.5 then to 8.1.5 (see Bug:1051830) 
 
  #2 This is not a typing error. 
     8.1.5 has no u0800060.SQL script. You can use u0800050.SQL instead. 
  #3 This upgrade script will remove the 8.1.5 or 8.1.6 Java system classes 
     automatically. In order to upgrade the system classes, you must run 
     $ORACLE_HOME/javavm/install/jvmu815.sql or  
     $ORACLE_HOME/javavm/install/jvmu816.sql manually after the rest of the  
     upgrade has been completed. This can take a long time.... 
           
 
Catalog scripts to run after the upgrade scripts 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
	   
   CATALOG.SQL and CATPROC.SQL are run by the uXXXXXXX.sql scripts. 
   However, you may need to run additional scripts depending on what  
   options are installed. 
   Eg: 
	 CATPARR.SQL   (only run if the Parallel Server option is installed)  
	 CATREP.SQL    (only run if the Replication option is installed) 
	 UTLRP.sql	This compiles INVALID packages and is included with 
			Oracle 8.0.5 onwards. It is advisable to run this 
			as the last script after upgrading. 
 
Note 
~~~~ 
 
  You MUST run CATALOG, CATPROC as INTERNAL or SYS, NOT SYSTEM. 
 
  Also, if you have installed additional packages or views the scripts for these  
  should also be run after to upgrade.  
  Eg: DBMSPOOL.SQL, CATPERF.SQL etc..