将转储文件导入到oracle 11gr2中会出现错误 [英] importing a dump file into oracle 11gr2 get errors

问题描述

将转储文件导入oracle 11gr2时出现此错误，请提出解决此问题的方法

While importing a dump file into oracle 11gr2 I am getting this error please suggest a way to resolve this

*Warning: the objects were exported by D7IDMP, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
. importing D7IDMP's objects into MIGRATE
. . importing table                    "TXALLTXTS"     245628 rows imported
. . importing table                       "TXAUTH"        377 rows imported
. . importing table                    "TXBAIMERT"        244 rows imported
. . importing table                     "TXBARESC"        178 rows imported
. . importing table                     "TXBOILER"     458940 rows imported
. . importing table                    "TXCLASSES"        980 rows imported
. . importing table              "TXCLOSEDPERIODS"          1 rows imported
. . importing table                  "TXCOMPANIES"          1 rows imported
. . importing table                 "TXCONCLAUSES"        187 rows imported
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE TABLE "TXCONFIGSETTINGS" ("CFS_CODE" VARCHAR2(20), "CFS_RCODE" VARCHAR2(2"
 "0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FR"
 "EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MP5TEXT" LOGGI"
 "NG NOCOMPRESS LOB ("CFS_XMLCONFIG") STORE AS  (TABLESPACE "MP5TEXT" ENABLE "
 "STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL 65536 FREE"
 "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'MP5TEXT' does not exist*

根据亚历克斯(Alex)的评论，我尝试了imp的其他属性，但导致了其他错误

As per Alex comments, I tried with other attributes of imp but it resulted in someother error

我运行的命令是

imp fromuser=d7idmp touser=&&from_user file=test.dmp log= test.log ignore=y transport_tablespace = y tablespaces = MP5TEXT

错误是

导入使用WE8MSWIN1252字符集和AL16UTF16 NCHAR完成字符集导出客户端使用WE8ISO8859P1字符集(可能字符集转换)IMP-00053:导入模式与导出不兼容转储文件IMP-00000:导入失败终止

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) IMP-00053: Import mode incompatible with Export dump file IMP-00000: Import terminated unsuccessfully

推荐答案

如果您可以使用datapump代替旧的 imp / exp 工具，则可以重新映射表空间(及其他事物).

If you are able to use datapump instead of the old imp/exp tools, you can remap tablespaces (and other things) on the fly.

否则，通常的处理方法是在新表空间中手动创建表，然后使用 ignore = y 运行 imp 不会抱怨该对象存在.

If not, the usual way to deal with this is to manually create the table in the new tablespace, and then run the imp with ignore=y so it doesn't complain that the object exists.

通过使用 indexfile =< file> 运行 imp ，可以使用旧表空间获取表的DDL.这将为您提供一个文本文件，其中包含用于表和索引的DDL，但带有 rem 的表命令已注释掉.您可以提取所需的位，并根据需要对新数据库进行编辑.

You can get the DDL for the table - with the old tablespace - by running imp with indexfile=<file>. This will give you a text file with the DDL for the tables and indexes, but with the table commands commented out with rem. You can extract the bits you need and edit them as required for the new database.

如果还没有，请查看在文档中导入参数.

这篇关于将转储文件导入到oracle 11gr2中会出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！