| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with this error message in Siebel 98 :- [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_CONTACT_IF_U1) violated
Shane wrote:
> Any help is urgently needed - we have a deadline to meet by the end of
> the week for data extraction.
>
> Does anyone have any ideas on how to resolve this error ?
>
> [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00001: unique constraint
> (SIEBEL.S_CONTACT_IF_U1) violated
>
> I am trying to extract data from Siebel Sales 98 and am using the
> following IFB file to do this through the Enterprise Integration
> Manager component in Server Tasks screen.
>
> [Siebel Interface Manager]
>       USER NAME = "SADMIN"
>       PASSWORD  = "SADMIN"
>       PROCESS   = Export All Contacts
>
> [Export All Contacts]
>       TYPE = SHELL
>       INCLUDE = Export Contacts
>
> [Export Contacts]
>       TYPE = EXPORT
>       BATCH = 200202
>       CLEAR INTERFACE TABLE = FALSE
>       EXPORT ALL ROWS = FALSE
>       EXPORT MATCHES = (FST_NAME like 'B%')
>       TABLE = S_CONTACT_IF
>       TABLE = S_CONTACT1_IF
>       TABLE = S_CONTACT2_IF
>       TABLE = S_CONTACT_DTLIF
If the point is to extract data ... forget Siebel and just use SQL*Plus.
Oh and I love your password.
Daniel Morgan Received on Mon Oct 14 2002 - 10:32:48 CDT
|  |  |