ITPub博客

首页 > Linux操作系统 > Linux操作系统 > expdp输出信息出现乱码

expdp输出信息出现乱码

原创 Linux操作系统 作者:myownstars 时间:2011-02-12 14:19:18 0 删除 编辑

采用expdp导出的时候,显示信息出现了很多???, 应该是字符集设置有问题
[oracle@db ~]$ expdp justin/justin directory=pump dumpfile=full_justin_110212.dmp

Export: Release 11.2.0.1.0 - Production on Sat Feb 12 13:29:06 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
?? "justin"."SYS_EXPORT_SCHEMA_02":  justin/******** directory=pump dumpfile=full_justin_110212.dmp
???? BLOCKS ??????...
?????? SCHEMA_EXPORT/TABLE/TABLE_DATA
?? BLOCKS ??????: 15.29 GB
?????? SCHEMA_EXPORT/USER
?????? SCHEMA_EXPORT/SYSTEM_GRANT
?????? SCHEMA_EXPORT/ROLE_GRANT
?????? SCHEMA_EXPORT/DEFAULT_ROLE
ORA-39127: ?? export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('justin',0,1,'11.02.00.00.00',newblock) ???????
ORA-04067: ???, package body "WMSYS.LT_EXPORT_PKG" ???
ORA-06508: PL/SQL: ???????? : "WMSYS.LT_EXPORT_PKG" ?????
ORA-06512: ? line 1
ORA-06512: ? "SYS.DBMS_METADATA", line 6961
?????? SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
?????? SCHEMA_EXPORT/SYNONYM/SYNONYM
?????? SCHEMA_EXPORT/TYPE/TYPE_SPEC
?????? SCHEMA_EXPORT/DB_LINK
?????? SCHEMA_EXPORT/SEQUENCE/SEQUENCE
?????? SCHEMA_EXPORT/TABLE/TABLE
?????? SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

用export重新设置一下
[oracle@db ~]$ export NLS_LANG=AMERICAN_AMERICA.UTF8

导出就好了
[oracle@db ~]$ expdp justin/justin directory=pump dumpfile=full_justin_110212.dmp

Export: Release 11.2.0.1.0 - Production on Sat Feb 12 13:31:21 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "justin"."SYS_EXPORT_SCHEMA_03":  justin/******** directory=pump dumpfile=full_justin_110212.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 15.32 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('justin',0,1,'11.02.00.00.00',newblock)
ORA-04067: not executed, package body "WMSYS.LT_EXPORT_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_EXPORT_PKG"
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 6961

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

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3112456