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