字符集修改引起的expdp impdp需要重新執行proc載入

用impdp匯入dmp檔案出現如下錯誤

[oracle@localhost ~]$ impdp zebra/zebra directory=back dumpfile=zebra20120420.dmp

Import: Release 10.2.0.1.0 - 64bit Production on Monday, 23 July, 2012 11:33:25

Copyright 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available


[oracle@localhost ~]$ oerr ora 39213
39213, 00000, "Metadata processing is not available"
// *Cause: The Data Pump could not use the Metadata API. Typically,
// this is caused by the XSL stylesheets not being set up properly.
// *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets
// to reload the stylesheets.

根據提示是後設資料程式不可用，給出的辦法也就是dbms_metadata_util.load_stylesheets
,手動執行後可以順利運用資料泵，不過這裡自己有點迷惑的是為什麼會造成此種錯誤。

[oracle@server134 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 23 12:35:41 2012

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, OLAP and Data Mining options

SQL> execute dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

想起之前執行了alter database character set interval_use zhs16gbk;。強制轉化了字符集，轉化字符集後導致資料泵工具無法使用需要重新載入設定，這裡也建議在建立資料庫時選擇合適的字符集，不然後續的轉換可能會給資料庫帶來一些影響。

[@more@]