熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle數據庫|exp導出問題

2013-11-13 15:55:08  來源: Oracle 

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

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

  Export: Release Production on Tue Nov ::

  Copyright (c) Oracle All rights reserved

  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

  System altered

  System altered

  PL/SQL procedure successfully completed

  Procedure dropped

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

  SQL> @?/rdbms/admin/utlrpsql

  PL/SQL procedure successfully completed

  PL/SQL procedure successfully completed

  驗證一下程序

  SQL> select * from ku$_xmlschema_view;

  V V OWNER_NUM OWNER_NAME URL

  

   MDSYS

   MDSYS

   MDSYS

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


From:http://tw.wingwit.com/Article/program/Oracle/201311/17514.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.