首页  >  文章  >  数据库  >  tts和字符集的关系--要求源和目的端的数据库字符集必须一样,国

tts和字符集的关系--要求源和目的端的数据库字符集必须一样,国

WBOY
WBOY原创
2016-06-07 15:58:571533浏览

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 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 encountered ORA-01017: invalid username/password; logon deniedUsername: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path About to import transportable tablespace(s) metadata... import done in ZHS16GBK character set and AL16UTF16 NCHAR character set export client uses AL32UTF8 character set (possible charset conversion) . importing SYS's objects into SYS . importing SYS's objects into SYS IMP-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 encountered ORA-29345: cannot plug a tablespace into a database using an incompatible character set ORA-06512: at "SYS.DBMS_PLUGTS", line 2386 ORA-06512: at "SYS.DBMS_PLUGTS", line 1946 ORA-06512: at line 1 IMP-00000: Import terminated unsuccessfully
AL32UTF8 上导出,ZHS16GBK 上导入 报的错。
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn