expdp在導(dǎo)數(shù)據(jù)庫(kù)時(shí)，發(fā)現(xiàn)存在以下異常

而且日志顯示不完全，如下：

;;;

Export: Release 11.2.0.1.0 - Production onThu Jan 13 12:27:49 2022

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

;;;

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

Starting"SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" directory=expdp1 dumpfile=exp01.dmplogfile=exp.log full=y;

Estimate in progress using BLOCKS method...

Processing object typeDATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 1.635GB

Processing object typeDATABASE_EXPORT/TABLESPACE

Processing object typeDATABASE_EXPORT/PROFILE

Processing object typeDATABASE_EXPORT/SYS_USER/USER

Processing object typeDATABASE_EXPORT/SCHEMA/USER

Processing object type DATABASE_EXPORT/ROLE

Processing object typeDATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT

Processing object typeDATABASE_EXPORT/SCHEMA/ROLE_GRANT

Processing object typeDATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

Processing object typeDATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA

Processing object typeDATABASE_EXPORT/RESOURCE_COST

Processing object typeDATABASE_EXPORT/SCHEMA/DB_LINK

Processingobject type DATABASE_EXPORT/TRUSTED_DB_LINK

Processingobject type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

Processingobject type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processingobject type DATABASE_EXPORT/DIRECTORY/DIRECTORY

Processingobject type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT

Processingobject type DATABASE_EXPORT/CONTEXT

Processingobject type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM

Processingobject type DATABASE_EXPORT/SCHEMA/SYNONYM

原因?yàn)榭蛻?hù)端與數(shù)據(jù)庫(kù)的字符集設(shè)置不一致導(dǎo)致

查詢(xún)客戶(hù)端字符集：

SQL> show parameter nls_lan

NAME TYPE VALUE

---------------------------------------------------------- --------------------

nls_language string AMERICAN

查詢(xún)數(shù)據(jù)庫(kù)字符集

SQL> select * fromnls_database_parameters where parameter='NLS_CHARACTERSET';

PARAMETER VALUE

-------------------------------------------------------

NLS_CHARACTERSET AL32UTF8

設(shè)置客戶(hù)端字符集

C:\Users\Administrator>set NLS_LANG=american_america.AL32UTF8

此后再來(lái)執(zhí)行導(dǎo)出操作，無(wú)異常發(fā)生，而且導(dǎo)出日志也能完全顯示。