导出语句:
expdp user/passwd directory=DATA_PUMP_DIR dumpfile=xx.dmp logfile=xx.log tables=xx
导入语句
impdp user/passwd DIRECTORY=DATA_PUMP_DIR dumpfile=xx.dmp logfile=xx.log table_exists_action = replace
导入报错
ORA-31693: Table data object "user"."table":"part1" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-24329: invalid character set identifier
源库字符集 和 目标库字符集一致:
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET ZHS16GBK
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
求助: 怎么查看解决问题。