Oracle數據庫|exp導出問題

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

　　[oracle@oracle ~]$ exp userid=test/test file=testdmp buffer= owner=test

　　Export: Release Production on Tue Nov ::

　　Connected to: Oracle Database g Enterprise Edition Release bit Production

　　With the Partitioning Real Application Clusters OLAP and Data Mining options

　　Export done in ZHSGBK character set and ALUTF NCHAR character set

　　About to export specified users

　　EXP: ORACLE error encountered

　　ORA: inconsistent datatypes: expected BLOB CLOB got CHAR

　　EXP: Export terminated unsuccessfully

　　原因數據字典中有存在一些無效KU$_視圖

　　SQL> select * from sysku$_xmlschema_view;

　　select * from sysku$_xmlschema_view

　　ERROR at line :

　　ORA: inconsistent datatypes: expected BLOB CLOB got CHAR

　　解決辦法

　　執行對象視圖定義腳本 $ORACLE_HOME/rdbms/admin/catmetxsql

　　SQL> @?/rdbms/admin/catmetxsql

　　Package altered

　　Index altered

　　View created

　　Grant succeeded

　　View created

　　Grant succeeded

　　Procedure created

　　System altered

　　PL/SQL procedure successfully completed

　　Procedure dropped

　　執行重新編譯無效對象腳本 $ORACLE_HOME/rdbms/admin/utlrpsql

　　SQL> @?/rdbms/admin/utlrpsql

　　PL/SQL procedure successfully completed

　　驗證一下程序

　　SQL> select * from ku$_xmlschema_view;

　　V V OWNER_NUM OWNER_NAME URL

　　 MDSYS

　　重新執行導出程序exp一些正常

From:http://tw.wingwit.com/Article/program/Oracle/201311/17514.html