Hi,
I have a requirement to load huge number of data files using SQL Loader. My requirement is to load the records sequentially with line number which can be achieved using Oracle Sequence object.
But I want to start the sequence with 1 every time I start with new file. Bit of research suggests 2 options to achieve this:
- Dropping & Re-Creating Sequence
- Alter Sequence and set it to 1
Since this is ongoing process, am not sure if above two options have impact on DB.
Experts, Is there any better way to achieve this?
Thanks & Regards,
Manohar