OraFAQ Forum: Server Utilities » Counter while loading via SQL Loader

Home » RDBMS Server » Server Utilities » Counter while loading via SQL Loader (Oracle 10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Counter while loading via SQL Loader [message #323170]

Tue, 27 May 2008 09:32

@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

Report message to a moderator

Re: Counter while loading via SQL Loader [message #323173 is a reply to message #323170]

Tue, 27 May 2008 09:47

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#i1008320

Report message to a moderator

Re: Counter while loading via SQL Loader [message #323177 is a reply to message #323173]

Tue, 27 May 2008 10:21

@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)

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:51:49 CDT 2024