本帖最后由 denglj 于 2022-1-15 10:48 编辑
expdp在导数据库时,发现存在以下异常 而且日志显示不完全,如下: ;;; 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
原因为客户端与数据库的字符集设置不一致导致 查询客户端字符集: SQL> show parameter nls_lan
NAME TYPE VALUE ---------------------------------------------------------- -------------------- nls_language string AMERICAN
查询数据库字符集 SQL> select * fromnls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE ------------------------------------------------------- NLS_CHARACTERSET AL32UTF8
设置客户端字符集 C:\Users\Administrator>set NLS_LANG=american_america.AL32UTF8
此后再来执行导出操作,无异常发生,而且导出日志也能完全显示。
|