How to upgrade a DB from 9.2.0.1 to 9.2.0.7 ???

Dear all,

I've just upgraded my Oracle software to version 9.2.0.7 because it corrects a bug found in 9.2.0.1.

OK, now the bug disappeared... but ....

Now I cannot use anymore IMP and EXP. I face the following error :

------------8<------------------8<------------------

C:\Temp>exp ME/password_at_database file=exp_file owner=ME

Export: Release 9.2.0.7.0 - Production on Tue Oct 4 15:22:06 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ME
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ME

EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

------------8<------------------8<------------------

I looked for upgrade scripts/tools/info and the like... localy and on the net (metalink, asktom, usenet, etc) without luck so far.

I found CATEXP.SQL and CATPATCH.SQL in %ORA_HOME%\rdbms\admin, but can't tell wether this is for 9.2.0.1 or 9.2.0.7...

I also tried, just to mentioned, the "Database Upgrade Assistant", but it tells me that my database is already in 9.2 format... Yes I know :-(

I can export & import data from a workstation that still has a 9.2.0.1 client installed, so I suspect the problem is quite small, but I'd like to know. Perhaps there is other issues that I did not find yet...

Can anyone give me any hints ?

My environment is :
- Windows 2000 server or Windows XP (databases on both platforms showing the same behavior)
- Oracle 9.2.0.7 patch applied on a 9.2.0.1 server & client software.

Thanks in advance,

Charly Received on Tue Oct 04 2005 - 09:39:40 CDT