92 积分	0 好友	0 主题

发消息

imp导入出现ORA-32603

1^#

发表于 2012-8-6 17:41:14 | 查看: 5858| 回复: 5

导入的数据库版本为10.2.0.5 DMP从10.2.0.1导出。 alertlog无信息。
imp导入数据的时候出现如下错误：

IMP-00017: following statement failed with ORACLE error 32603:
"CREATE TABLE "T_SYS_LOG" ("ID" NUMBER(19, 0) NOT NULL ENABLE, "CREATETIME" "
"DATE, "CREATOR" NUMBER(19, 0), "ENTITYID" VARCHAR2(255), "ENTITYNAME" VARCH"
"AR2(1000), "IPADDRESS" VARCHAR2(20), "URL" VARCHAR2(4000), "MODULE_NAME" VA"
"RCHAR2(255), "CONTENT" CLOB, "EXCEPTION" CLOB)  PCTFREE 10 PCTUSED 40 INITR"
"ANS 1 MAXTRANS 255 STORAGE(INITIAL 655360 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) TABLESPACE "HDDS_CLPS_DTA_DATA" LOGGING NOCOMPRESS LOB (""
"EXCEPTION") STORE AS  (TABLESPACE "HDDS_CLPS_DTA_DATA" ENABLE STORAGE IN RO"
"W CHUNK 8192 RETENTION FREEPOOLS 65535 NOCACHE LOGGING  STORAGE(INITIAL 655"
"36 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CONTENT") STOR"
"E AS  (TABLESPACE "HDDS_CLPS_DTA_DATA" ENABLE STORAGE IN ROW CHUNK 8192 RET"
"ENTION FREEPOOLS 65535 NOCACHE LOGGING  STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 32603 encountered
ORA-32603: invalid FREEPOOLS LOB storage option value

手动创建改表正常，手动创建后用ignore=Y导入数据也失败。我估计是和LOB字段有关系，各位大神看看怎么解决。

导入的数据库版本为10.2.0.5  DMP从10.2.0.1导出。 alertlog无信息。

[ 本帖最后由爬树的熊于 2012-8-6 17:50 编辑 ]

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-8-6 17:44:48

一个好的问题的基本要素：一个好的标题、　完整的版本信息、完整的日志信息、报错信息

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2012-8-6 18:01:13

这是一个bug ，考虑去掉FREEPOOLS 属性先行创建该表，之后单独导入该表的数据

Bug 6873515  ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute

This note gives a brief overview bug 6873515.
The content was last updated on: 23-SEP-2008
Click here for details of each of the sections below.
Affects:

Product (Component)    Oracle Server (Rdbms)
Range of versions believed to be affected    Versions >= 10.2.0.4 but BELOW 11.2
Versions confirmed as being affected
11.1.0.6
10.2.0.4
Platforms affected    Generic (all / most platforms affected)

It is believed to be a regression in default behaviour thus:
Regression introduced in 10.2.0.4
Regression introduced in 11.1.0.6
Fixed:

This issue is fixed in
11.1.0.7 (Server Patch Set)
10.2.0.5 (Server Patch Set)
Symptoms:

Related To:

Error May Occur
ORA-32602
Export/Import
Datatypes (LOBs/CLOB/BLOB/BFILE)
Description

This problem is introduced in 10.2.0.4 and 11.1.0.6 .

Import of a table containing a LOB column with a FREEPOOLS
attribute set fails to import with ORA-32602.

eg:
CREATE TABLE lob_demo(lob1 BLOB, lob2 blob)
  LOB (lob1) STORE AS lob_demo_lob1(RETENTION FREEPOOLS 2)
  LOB (lob2) STORE AS lob_demo_lob2;

Export / import this table using conventional exp/imp

Note:
  In earlier releases this error does not occur but
  the problem in bug 5176017 occurs.

回复只看该作者道具举报