IMP-00078: Cannot translate FILE locator to "string" "string" in server character set

IMP-00078: Cannot translate FILE locator to "string" "string" in server character set
Cause: (1) The current export dump file was generated using Beta-2 of Oracle8.0 AND (2) there was a File that appeared as an an attribute of an ADT within a table's column AND (3) the character set of the export server's database was different than the character set of the import server's database AND (4) when the filename or the aliasname of the File increased in size when it was translated to the character set of the import server. When all of these conditions are true, translation of the strings could yield corruption of the data in the column. Rather than proceeding with the translation, import will leave the character strings in the File in the old character set.
Action: After import completes, rename the directory aliases and external filenames to match the real names used for the target database.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:47

IMP-00078：无法将FILE定位器转换为服务器字符集中的“ 字符串 ”“ 字符串 ”,
.原因：（1）当前导出转储文件是使用Oracle8.0的Beta-2生成的，并且（2）有一个文件作为表的列中的ADT的属性出现，以及（3）字符集导出服务器的数据库不同于导入服务器的数据库的字符集AND（4）当文件的文件名或别名被翻译为导入服务器的字符集时大小增加。当所有这些条件都为真时，字符串的翻译可能导致列中的数据的损坏。导入不会继续翻译，而是将文件中的字符串留在旧的字符集中。,
.操作：导入完成后，重命名目录别名和外部文件名以匹配用于目标数据库的实名。,
.

aiaiDBA

13718043309

010-86462881

IMP-00078: Cannot translate FILE locator to "string" "string" in server character set

1 个回答

相似问题