1、系统字符集信息
(1) NLS_LANG
NLS_LANG=AMERICAN.AMERICA.US7ASCII
(2) PROP$
NAME VALUE$ COMMENT$
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
NLS_CHARACTERSET US7ASCII Character set
(3) COL$
CHARACTERSET TYPES_USED_IN
US7ASCII CLOB
AL16UTF16 NCLOB
US7ASCII VARCHAR2
AL16UTF16 NVARCHAR2
US7ASCII CHAR
AL16UTF16 NCHAR
2、故障现象
进行导出时出现如下错误
c:\>expdp system/system_pas directory=exp1 tables=erp.capp_resource
Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 07 January, 2010 21:57:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_04": system/******** directory=exp1 tables=erp.capp_resource
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 185.1 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1352
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 7073
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2829
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00216: invalid character 208 (0xD0
Job "SYSTEM"."SYS_EXPORT_TABLE_04" stopped due to fatal error at 21:58:24
ORA-39014: One or more workers have prematurely exited.
不知道是否字符集问题,请高手指导,在线等
------解决方案--------------------
没人回答，结贴了吧
可以用EXP FULL方式导出
------解决方案--------------------
expdp导出的话与本地设的字符集无关。你以表模式导出的话 tables=(table1,table2)