tts和字符集的关系–要求源和目的端的数据库字符集必须一样，国家字符集必须一样。 imp sys/as TRANSPORT_TABLESPACE=Y da本文来源gao($daima.com搞@代@#码(网5tafiles= C:\oracle\product\10.2.0\oradata\a\test01.dbf’ file=c:\tts_test.dmp log=c:\imp_tts.log IMP-00058: ORACLE error 1017 e
tts和字符集的关系–要求源和目的端的数据库字符集必须一样，国家字符集必须一样。
imp sys/as TRANSPORT_TABLESPACE=Y datafiles= C:\oracle\product\10.2.0\oradata\a\test01.dbf’ file=c:\tts_test.dmp log=c:\imp_tts.log
IMP-00058: ORACLE error 1017 encounteredORA-01017: invalid username/password; logon deniedUsername: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit ProductionWith the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional pathAbout to import transportable tablespace(s) metadata…import done in ZHS16GBK character set and AL16UTF16 NCHAR character setexport client uses AL32UTF8 character set (possible charset conversion). importing SYS’s objects into SYS. importing SYS’s objects into SYSIMP-00017: following statement failed with ORACLE error 29345: “BEGIN sys.dbms_plugts.beginImport (‘9.2.0.1.0′,873,’2000′,NULL,’NULL’,303” “17,21201,1); END;”IMP-00003: ORACLE error 29345 encounteredORA-29345: cannot plug a tablespace into a database using an incompatible character setORA-06512: at “SYS.DBMS_PLUGTS”, line 2386ORA-06512: at “SYS.DBMS_PLUGTS”, line 1946ORA-06512: at line 1IMP-00000: Import terminated unsuccessfully
AL32UTF8 上导出，ZHS16GBK 上导入 报的错。
转载请注明原文链接：tts和字符集的关系–要求源和目的端的数据库字符集必须一样，国
