Need some help on using RECNUM feature of SQL*Loader 7.3
From: Creative Business Advisers <health_at_mtolympus.ari.net>
Date: 1996/09/25
Message-ID: <52bjds$dsr_at_ari.ari.net>#1/1
Date: 1996/09/25
Message-ID: <52bjds$dsr_at_ari.ari.net>#1/1
I am using Oracle SQL*Loader version 7.3.
When I use the RECNUM feature, I receive an Oracle error message
ORA-00001 - "unique constraint table.column violated"
The exact statements I typed that caused the ORA-00001 message were:
Load Data
In File common.dat
Append
into table common
fields terminated by X'1E'
(concept_ui,find,vocstat,findkey RECNUM)
I am using RECNUM to insert a unique number into the FINDKEY field.
Any tips or advice on how to properly use RECNUM in SQL*Loader would be greatly appreciated. Thank you very much.
- Mike