oracle中ipm导出语句,ipm的问题 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@dr temp]$ imp system/oracle file=20111020db01.dmp fromuser=VSSDR touser=VSSDR;

Import: Release 10.2.0.1.0 - Production on Thu Oct 13 06:14:42 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses WE8ISO8859P1 character set (possible charset conversion)

. importing VSSDR's objects into VSSDR

. . importing table                         "BOOK"          1 rows imported

IMP-00017: following statement failed with ORACLE error 14063:

"ALTER TABLE "BOOK" ADD  CONSTRAINT "PK_BOOK" PRIMARY KEY ("BOOKNO") USING I"

"NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 F"

"REELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX_SPC_DR" LOGGING"

IMP-00003: ORACLE error 14063 encountered

ORA-14063: Unusable index exists on unique/primary constraint key

IMP-00017: following statement failed with ORACLE error 14048:

"ALTER INDEX "PK_BOOK" UNUSABLE ENABLE "

IMP-00003: ORACLE error 14048 encountered

ORA-14048: a partition maintenance operation may not be combined with other operations

. . importing table              "CANCELEIREADLOG"          0 rows imported

. . importing table                "CANCELINSTALL"          0 rows imported

. . importing table            "CANCELINSTALLITEM"          0 rows imported

. . importing table                     "CATEGORY"       5264 rows imported

IMP-00017: following statement failed with ORACLE error 14063:

"ALTER TABLE "CATEGORY" ADD  CONSTRAINT "PK_CATEGORY" PRIMARY KEY ("CATEGORY"

"ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 F"

"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX_SPC_DR" "

"LOGGING"

IMP-00003: ORACLE error 14063 encountered

ORA-14063: Unusable index exists on unique/primary constraint key

IMP-00017: following statement failed with ORACLE error 14048:

"ALTER INDEX "PK_CATEGORY" UNUSABLE ENABLE "

IMP-00003: ORACLE error 14048 encountered

ORA-14048: a partition maintenance operation may not be combined with other operations

. . importing table            "CAT_CANCELINSTALL"          0 rows imported

. . importing table              "CAT_ELECINSTALL"          0 rows imported

. . importing table                "CAT_GOODSSHOP"          0 rows imported

. . importing table                    "CAT_ORDER"      37370 rows imported

到这里就不动了

里面的报错是不是我导出的时候没保持一致性？为什么现在会死在这里，我是同一个库里面，先删除vssdr及其对象,再导入vssdr及其对象？

有人说是字符集的问题，服务器端：NLS_CHARACTERSET WE8ISO8859P1 ，oracle环境变量中，我没有设置字符集，导入的时候我也没有exprot nls_lang='WE8ISO8859P1',会不会是这个问题？