from oracle 8.1.7.2 to 8.1.7.4, what about database migration

[Ogzilal]

Hello world,

I am running Oracle 8.1.7.4 on aix5.1 box.
I am experiencing some problems after a cold restore of an old copy of a databse created under Oracle 8.1.7.2/AIX 4.3.3 . The problem appears when trying to do an export of the restored databse.

EXP-00008: Erreur ORACLE 904 (ORACLE error 904 encountered)
ORA-00904: Nom de colonne non valide (Invalid column name)

Is there a script to run or something else to do for upgrading dabase 8.1.7.2 to 8.1.7.4 ?
In advance, thank You.

Ali

 

[markrem]

The upgrade instructions are found in the ReadMe.htm file that is included with patch set 8.1.7.4. The upgrade process probably includes running the new versions of catalog.sql and catproc.sql against your old database, as this upgrades the dictionary tables to the new version.

There is no "migration" for your case. The data block headers will not be updated.

-Mark

9i OCP

 

[Ogzilal]

Thanks mrkrem fory your reply,
I runned catexp.sql and the export is done correctly.

Ali