All,
I had a look at the Oracle Documentation on SQLLoader when using MAX or COUNT to generate a value to insert into a column like ROW_ID.
ROW_ID sequence(COUNT,1)
However I could not find out how this functionality works and how efficient it is during large batch loads of data.
That is why I am considering using a Sequence object instead of MAX or COUNT.
Can someone give me or point me to a definitive answer on how COUNT function works?
Does it only do a full table scan once to get the row count and then just increment after each Insert, or does it do a Rowcount after each insert from a data file?
I tried using a sequence object as an alternative but it did not like my syntax
ROW_ID "Siebel.mysequence.nextval"
I used this example in the forum
Want to use sequence object of oracle when loading data in sql loader
Thanks