dear all,
I am importing database from dmp file now and get some error msg
during the process.
IMP-00017: following statement failed with ORACLE error 2437:
"ALTER TABLE "AUTOMATIC_POSTING_ROW_TAB" ADD ONSTRAINT
"AUTOMATIC_POSTING_"
"ROW_PK" PRIMARY KEY
("COMPANY","VALID_FROM","ROW_NO","AUTOMATIC_RULE_ID") U"
"SING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 204800
NEXT "
"2097152 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 )
TABLESPACE "
""FND_DATA""
IMP-00003: ORACLE error 2437 encountered
ORA-02437: cannot enable (IFSAPP.AUTOMATIC_POSTING_ROW_PK) - primary
key violated
. . importing table ????22AUTOMATIC_POSTING_RPT" ????? rows imported
. . importing table ????22AUTOMATIC_POSTING_TAB" ????46 rows imported
IMP-00017: following statement failed with ORACLE error 2437:
"ALTER TABLE "AUTOMATIC_POSTING_TAB" ADD ONSTRAINT
"AUTOMATIC_POSTING_PK" "
"PRIMARY KEY ("COMPANY","AUTOMATIC_RULE_ID","VALID_FROM") USING INDEX
PCTFRE"
"E 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 204800 NEXT 2097152
MINEXTENT"
"S 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 ) TABLESPACE "FND_DATA""
IMP-00003: ORACLE error 2437 encountered
ORA-02437: cannot enable (IFSAPP.AUTOMATIC_POSTING_PK) - primary key
violated
IMP-00020: long column too large for column buffer size (30557)
What should I do after the import process done?
Where I can find the information about all error which PK or other
constrains missing?
please give a hint.
Thanks in advance,
regards,
JK
Received on Wed Aug 08 2001 - 23:46:35 CDT
