字符集修改引起的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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25362835/viewspace-1058982/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25362835/viewspace-1058982/