From: jkyf0131@hotmail.com (JK Yao)
Newsgroups: comp.databases.oracle.server
Subject: IMPORT UTL. #1 (PK conflicted)
Date: 8 Aug 2001 21:46:35 -0700
Organization: http://groups.google.com/
Lines: 44
Message-ID: <93f65984.0108082046.3c1e5f42@posting.google.com>
NNTP-Posting-Host: 208.23.58.225
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997332396 22833 127.0.0.1 (9 Aug 2001 04:46:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Aug 2001 04:46:36 GMT


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 &#60958;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 &#60958;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