1 Reply Latest reply on Dec 21, 2005 2:35 PM by Nicolas Gasparotto

    Import/Export problems after patching oracle from 9.2.0.1 to 9.2.0.5

    411850
      Hi, After I applied the 5 patch to oracle 9201 on Win XP the export utility has started to complain about
      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

      And after I applied catexp.sql script, it didn't fix the issue with export, the error message has become like this:

      EXP-00056: ORACLE error 31600 encountered
      ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
      ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
      ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
      ORA-06512: at "SYS.DBMS_METADATA", line 836
      ORA-06512: at line 1
      EXP-00000: Export terminated unsuccessfully

      Can someone advise, what's wrong with it? With oracle 9.2.0.1 export worked fine, after upgrade to 9.2.0.5 it fails every time it gets to the table data export stage.

      Thanks in advise