hi
I' ve a problem during an import with partionned tables
I did this :
under UNIX:
1. exp from 8.1.5.1.0 + imp to 8.1.7.0.
2. exp from 8.1.5.1.0 + imp to 8.1.5.0.
In 1. and 2., the same bad results, imp works well EXCEPTED for my PARTITIONNED table :((
my partionned table is created, but not its PRIMARY key (and, of course, not its constraint and not its indexe)
error mesage :
IMP-00003: ORACLE error 2212 encountered
ORA-02212: duplicate PCTFREE option specification
'DUPLICATED PCTFREE' ok, but it's not ME who generates that DDL script .
It's Oracle Export Utility has made a BAD script! (I suppose, in fact)
I want to say we don't have much control of DMP file ... (just some parameters)
Is-it a BUG (what about the fix) ? Have I do a bad thing ? or else ?
I know I can create the partionned table before imp.
but I would like understand ...
Thanks in advance
Vincent
below found the import log and DDL script of my partitioned table
Sorry for that very long log :
Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
(...)
IMP-00017: following statement failed with ORACLE error 2212:
"ALTER TABLE "RM_DOCUMENTS" ADD CONSTRAINT "RM_DC_PK" PRIMARY KEY ("RMN_DC_"
"BA_ID","RMC_DC_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE"
"(INITIAL 4194304 NEXT 4194304 PCTINCREASE 0) TABLESPACE "MIN2_I" LOGGING LO"
"CAL(PARTITION "MIN2_RMD_1" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 8396800 NEXT 4194304 MINEXTENTS 2 MAXEXTENTS 2147483645 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MIN2_I" LOGGI"
"NG, PARTITION "MIN2_RMD_2" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 8396800 NEXT 4194304 MINEXTENTS 2 MAXEXTENTS 2147483645 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MIN2_I" LOGGI"
"NG, PARTITION "MIN2_RMD_3" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 8396800 NEXT 4194304 MINEXTENTS 2 MAXEXTENTS 2147483645 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MIN2_I" LOGGI"
"NG, PARTITION "MIN2_RMD_4" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 8396800 NEXT 4194304 MINEXTENTS 2 MAXEXTENTS 2147483645 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MIN2_I" LOGGI"
"NG, PARTITION "MIN2_RMD_5" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 8396800 NEXT 4194304 MINEXTENTS 2 MAXEXTENTS 2147483645 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MIN2_I" LOGGI"
"NG ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 2097152 NEXT 20971"
"52) TABLESPACE "MIN2_I" LOGGING LOCAL(PARTITION "MIN2_RMD_1" PCTFREE 10 IN"
"ITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4198400 NEXT 2097152 MINEXTENTS 2 MAX"
"EXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "MIN2_I" LOGGING, PARTITION "MIN2_RMD_2" PCTFREE 10 IN"
"ITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4198400 NEXT 2097152 MINEXTENTS 2 MAX"
"EXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "MIN2_I" LOGGING, PARTITION "MIN2_RMD_3" PCTFREE 10 IN"
"ITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4198400 NEXT 2097152 MINEXTENTS 2 MAX"
"EXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "MIN2_I" LOGGING, PARTITION "MIN2_RMD_4" PCTFREE 10 IN"
"ITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4198400 NEXT 2097152 MINEXTENTS 2 MAX"
"EXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "MIN2_I" LOGGING, PARTITION "MIN2_RMD_5" PCTFREE 10 IN"
"ITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4198400 NEXT 2097152 MINEXTENTS 2 MAX"
"EXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "MIN2_I" LOGGING ) ENABLE "
IMP-00003: ORACLE error 2212 encountered
ORA-02212: duplicate PCTFREE option specification
(...)
Import terminated successfully with warnings.
DDL Script is :
CREATE TABLE RM_DOCUMENTS (
RMN_DC_BA_ID NUMBER (20) NOT NULL,
RMC_DC_ID VARCHAR2 (50) NOT NULL,
RMC_DC_DM_ID VARCHAR2 (10) NOT NULL,
RMC_DC_FLG_MODIF VARCHAR2 (1),
RMC_DC_FLG_ARCHI VARCHAR2 (1),
RMC_DC_CREATEUR VARCHAR2 (50),
RMD_DC_DAT_CREAT DATE,
RMC_DC_MODIFICATEUR VARCHAR2 (50),
RMD_DC_DAT_MODIF DATE,
CONSTRAINT RM_DC_PK
PRIMARY KEY ( RMN_DC_BA_ID, RMC_DC_ID ))
NOCACHE
PARTITION BY RANGE (RMN_DC_BA_ID)
(
PARTITION MIN2_RMD_1 VALUES LESS THAN (5) TABLESPACE MIN2_T_4
PCTFREE 10
PCTUSED 75
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 20971520
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_2 VALUES LESS THAN (6) TABLESPACE MIN2_T_5
PCTFREE 10
PCTUSED 75
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 20971520
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_3 VALUES LESS THAN (15) TABLESPACE MIN2_T_3
PCTFREE 10
PCTUSED 75
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 20971520
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_4 VALUES LESS THAN (23) TABLESPACE MIN2_T_2
PCTFREE 10
PCTUSED 75
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 20971520
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_5 VALUES LESS THAN (MAXVALUE) TABLESPACE MIN2_T_1
PCTFREE 10
PCTUSED 75
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 20971520
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
)
);
ALTER TABLE MIN2_ADM.RM_DOCUMENTS ADD CONSTRAINT RMX_DC_DM_FK
FOREIGN KEY (RMN_DC_BA_ID, RMC_DC_DM_ID)
REFERENCES MIN2_ADM.RM_DOMAINES (RMN_DM_BA_ID, RMC_DM_ID) ;
CREATE INDEX RMX_DC_DM_FK ON
RM_DOCUMENTS(RMN_DC_BA_ID, RMC_DC_DM_ID)
LOCAL
(
PARTITION MIN2_RMD_1 TABLESPACE MIN2_I
PCTFREE 10
STORAGE (
INITIAL 2097152
NEXT 2097152
PCTINCREASE 0
MINEXTENTS 2
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_2 TABLESPACE MIN2_I
PCTFREE 10
STORAGE (
INITIAL 2097152
NEXT 2097152
PCTINCREASE 0
MINEXTENTS 2
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_3 TABLESPACE MIN2_I
PCTFREE 10
STORAGE (
INITIAL 2097152
NEXT 2097152
PCTINCREASE 0
MINEXTENTS 2
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_4 TABLESPACE MIN2_I
PCTFREE 10
STORAGE (
INITIAL 2097152
NEXT 2097152
PCTINCREASE 0
MINEXTENTS 2
MAXEXTENTS 2147483645
),
PARTITION MIN2_RMD_5 TABLESPACE MIN2_I
PCTFREE 10
STORAGE (
INITIAL 2097152
NEXT 2097152
PCTINCREASE 0
MINEXTENTS 2
MAXEXTENTS 2147483645
)
);
