oracle导入错误 [英] oracle import error

问题描述

将转储文件导入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 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：导入模式与Export
转储文件不兼容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 =运行 imp y 所以它不会抱怨该对象存在。

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.

您可以通过运行获取表的DDL（使用旧表空间） imp ， indexfile =< file> 。这将为您提供一个带有表和索引的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.

如果您还没有，请查看导入参数。

If you haven't already, look at the import parameters in the documentation.

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