The relationship between TTS and character sets-requires that the database character set of the source and destination must be the same, and the national character set must be the same.
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 P Artitioning, 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 chars ET conversion). Importing sys ' s objects into SYS. Importing SYS ' s objects to sysimp-00017:following statement failed with ORACLE error 29345: "BEGIN sys.dbms_plugts.be Ginimport (' 9.2.0.1.0 ', 873, ' n ', NULL, ' null ', 303 "" 17,21201,1); END; " Imp-00003:oracle Error 29345 encounteredOra-29345:cannot plug a tablespace to 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 on the export, ZHS16GBK on the import report error.
