exp匯出的問題

昨天payment從測試庫到另外一個測試庫進行遷移，匯出時，出現如下故障：

[oracle@oracle02 ~]$ exp userid=test/test file=test.dmp buffer=1024 owner=test

Export: Release 10.2.0.1.0 - Production on Tue Nov 28 15:09:42 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...

.EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

EXP-00000: Export terminated unsuccessfully

原因：資料字典中有存在一些無效KU$_視圖；

SQL> select * from sys.ku$_xmlschema_view;

select * from sys.ku$_xmlschema_view

*

ERROR at line 1:

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

解決辦法：

1.執行物件檢視定義指令碼 $ORACLE_HOME/rdbms/admin/catmetx.sql

SQL> @?/rdbms/admin/catmetx.sql

Package altered.

Index altered.

View created.

Grant succeeded.

View created.

Grant succeeded.

Procedure created.

System altered.

System altered.

System altered.

PL/SQL procedure successfully completed.

Procedure dropped.

2.執行重新編譯無效對象指令碼 $ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> @?/rdbms/admin/utlrp.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

驗證一下程式

SQL> select * from ku$_xmlschema_view;

V V OWNER_NUM OWNER_NAME URL

- - ---------- ------------------------------ ---------------

1 0 46 MDSYS http://www.opengis.net/gml/geometry.xsd

1 0 46 MDSYS http://www.w3.org/1999/xlink/xlinks.xsd

1 0 46 MDSYS http://www.opengis.net/gml/feature.xsd

重新執行匯出程式exp，一些正常。