Thanks Fred , Terry I was able to fix this .... It was quick :)
Cheers ! Thanks & Regards, Himanshu Kohli Senior ITSM Consultant, Wipro/Cmango - Business Service Management 19023| Gallop Drive|Maryland, MD 20874 Mobile: 469.426.8475| Off: 703-860-6111| Skype: Himanshu.Kohli [EMAIL PROTECTED] | www.cmango.com | www.wipro.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma Sent: Tuesday, March 27, 2007 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: Error ORA-01452 CREATE UNIQUE INDEX The reason you are having this problem is because I suspect you are trying to import the schema "in place" and there are duplicate asset records in your database for a unique index that has been defined for AST:Asset. If you know what your column your unique index is on, you can find the offending data occurrences using the following SQL code: Select <column>, count(*) from AST_Asset group by <column> having count(*) > 1 replacing <column> with your column name that the unique index is on... Terry -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kohli Himanshu-NXJ743 Sent: Tuesday, March 27, 2007 11:31 AM To: arslist@ARSLIST.ORG Subject: Error ORA-01452 CREATE UNIQUE INDEX Hi Folks Every time I am trying to make an import of AST:Asset form from another Remedy server to this server I get this error "ORA-01452 ORA-01452 CREATE UNIQUE INDEX" The two field ID's that are shown in the reason of conflict are :- 2000000004 = > Item , DATATYPE = Character , Entry Mode = Required 2000000001 = > Serial Number , DATATYPE = Character , Entry Mode = Required AST:Asset Schema details FIELDID FIELDTYPE OWNER LASTCHANGED DATATYPE FOPTION CREATEMODE ---------- ---------------------------------------- ---------- ---------- ------------------------------ ------------------------------ 200000003 1 Demo Demo 4 1 1 200000004 1 Demo Demo 4 1 1 200000005 1 Demo Demo 4 1 1 200000001 1 Demo Demo 4 1 1 I have attached a screen short of the error message with this request Please advise ... Thanks & Regards, Himanshu Kohli Senior ITSM Consultant, Wipro- Business Service Management 19023| Gallop Drive|Maryland, MD 20874 Mobile: 469.426.8475| Off: 703-860-6111| Skype: Himanshu.Kohli [EMAIL PROTECTED] | www.cmango.com | www.wipro.com ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"