首页 > 代码库 > tts和字符集的关系--要求源和目的端的数据库字符集必须一样，国家字符集必须一样。

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

2024-07-14 11:01:05   221人阅读

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 上导入 报的错。


联系
我们