Post: resolves the error from 9.2.0.1 to 9.2.0.7.

Original post address: connect 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
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been exported. The specified user will be exported soon...
. Exporting objects and operations in the pre-schema Process
. Exporting User BJIC's external function library name
. Export PUBLIC type Synonyms
. Export private type Synonyms
. Exporting User BJIC Object Type Definition
The BJIC object to be exported...
. Exporting database link...
. Exporting sequence number
. Exporting cluster definition...
EXP-00056: ORACLE error 19206
ORA-19206: the value for the query or ref cursor parameter is invalid
ORA-06512: In "SYS. DBMS_XMLGEN", line 83
ORA-06512: In "SYS. DBMS_METADATA", line 345
ORA-06512: In "SYS. DBMS_METADATA", line 410
ORA-06512: In "SYS. DBMS_METADATA", line 449
ORA-06512: In "SYS. DBMS_METADATA", line 1156
ORA-06512: In "SYS. DBMS_METADATA", line 1141
ORA-06512: In line 1
EXP-00000: Export Termination failure work und:
SQL> @ d: \ oracle \ ora92 \ rdbms \ admin \ catmeta. SQLThen export the data. The following error occurs: connect 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
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
Note: No table data (rows) will be exported to the specified user...
. Exporting objects and operations in the pre-schema Process
. Exporting User BJIC's external function library name
. Export PUBLIC type Synonyms
. Export private type Synonyms
. Exporting User BJIC Object Type Definition
EXP-00008: ORACLE error 942
ORA-00942: Table or view does not exist
EXP-00024: Export view not installed, please notify your DBA
EXP-00000: Export termination failed cause of this error: Because the exp version is different from the database version,
Although the installation package of 9.2.0.7 has been successfully installed, the confidence in the data dictionary table is updated,
View through this statement
SQL> select comp_id, version from dba_registry;COMP_ID VERSIONCATALOG 9.2.0.1.0
CATPROC 9.2.0.1.0
OWM 9.2.0.1.0
JAVAVM 9.2.0.1.0
XML 9.2.0.2.0
CATJAVA 9.2.0.1.0
ORDIM 9.2.0.1.0
SDO 9.2.0.1.0
CONTEXT 9.2.0.1.0
XDB 9.2.0.1.0
WK 9.2.0.1.0
ODM 9.2.0.1.0
APS 9.2.0.1.0
XOQ 9.2.0.1.0
AMD 9.2.0.1.0C: \ Documents ents and Settings \ Administrator> sqlplus/nologSQL * Plus: Release 9.2.0.7.0-Production on Friday September 29 12:34:11 2006 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. SQL> conn sys/sys @ dw as sysdba
Connected.
SQL> shutdow immediate
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled. SQL> startup migrate
The ORACLE routine has been started. Total System Global Area 1687760036 bytes
Fixed Size 457892 bytes
Variable Size 486539264 bytes
Database Buffers 1199570944 bytes
Redo Buffers 1191936 bytes
The database has been loaded.
The database has been opened.
SQL> spool d: \ catpatch. log
SQL> @ d: \ oracle \ ora92 \ rdbms \ admin \ catpatch. SQL
SQL> spool off
Note: In catpatch, catexp is called to modify exp. So far, exp is successfully modified.
Exp exported successfully