Home » RDBMS Server » Server Utilities » Counter while loading via SQL Loader (Oracle 10.2)
Counter while loading via SQL Loader [message #323170] Tue, 27 May 2008 09:32 Go to next message
@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member
Hi,

Is it possible while loading data via SQL Loader, we can somehow introuduce logic in the control file, that will load a counter on a column that keeps on incrementing as each record loads.

We need the load sequence of the flat file and dont want to rely on the rowid.

Thanks.
Arpita
Re: Counter while loading via SQL Loader [message #323173 is a reply to message #323170] Tue, 27 May 2008 09:47 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8623
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#i1008320
Re: Counter while loading via SQL Loader [message #323177 is a reply to message #323173] Tue, 27 May 2008 10:21 Go to previous message
@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member
Hey thanks.

We were planning to work with the RECNUM option as we dont want to maintain the sequence, but restart the counter from 1 everytime the SQL Loader runs(per requirement, we just want the sequence of one lot of records loaded, not across lots)
Previous Topic: EXP-00003: no storage definition found in export
Next Topic: datapump import error: ORA-39014: One or more workers have prematurely exited (merged)
Goto Forum:
  


Current Time: Sat Dec 03 09:58:07 CST 2016

Total time taken to generate the page: 0.15111 seconds