Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Upgrade 8i db to 9.2.0.4

Re: Upgrade 8i db to 9.2.0.4

From: Marcin Buchwald <velvet_at_agora.pl>
Date: Mon, 17 Nov 2003 13:21:16 +0100
Message-ID: <bpaeg1$9lf$1@pippin.warman.nask.pl>


I choose the second path as ora docs says that there is direct upgrade path from ver 8.1.7.0

My "script order" contains steps as

  1. alter package standard compile;
  2. @C:\OraW2K3\rdbms\admin\u0801070.sql
  3. @C:\OraW2K3\rdbms\admin\cmpdbmig.sql
  4. @C:\OraW2K3\rdbms\admin\catqueue.sql
  5. @C:\OraW2K3\rdbms\admin\catstr.sql
  6. alter package standard compile;
  7. @C:\OraW2K3\rdbms\admin\utlrp.sql

Steps 13 and 14 are required to get rid off all objects with status 'INVALID'. After this steps all objects are 'VALID' and my database works just fine.

Regards,

        Marcin Received on Mon Nov 17 2003 - 06:21:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US