Re: Error importing a thesaurus with ctxload

Are you importing into existing tables? If so, check to see if there is an additional constraint on the unix side. This error should exist on both systems. It is an index constraint. Look at DBA_INDEXES and see if there are additional indexes on the unix side. If not there, check DBA_CONSTRAINTS and find out the same thing. Don't look at the names - look at the count. If the names are system generated they will most likely be different.

Teppicamon wrote:

> Hi all
>
> We're experiencing a very weird problem importing a thesaurus through
> ctxload. We have a thesaurus text file with some duplicated phrases on it
> (and yes, we know it, that shouldn't be like that but the file is really
> huge and we'd rather avoid checking it again. Follow on, please...) and we
> make the import with Oracle 9.2 / Windows 2000. No problem, ctxload seems to
> know how to handle the duplicated records and the import ends correctly. But
> then we try to import on Oracle 9.2 / Unix. Then the file is parsed
> correctly but when ctxload starts to insert we get this error:
>
> Beginning insert...DRG-50857: oracle error in drzmiip
> ORA-00001: unique constraint (CTXSYS.DR_UNIQ_THS_PHRASE) violated
>
> Is that normal? Why this difference between Windows and Unix versions? Is
> there anything we can do to make the Unix ctxload behave like the Windows
> ctxload?
>
> Any idea will be very welcome...
> ---
> F.X. Gil
>
>
Received on Tue Oct 28 2003 - 14:26:49 CST