Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLLoader performance using Count vs Sequence Object

loosebruceNov 22 2013 — edited Nov 22 2013

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

This post has been answered by Barbara Boehmer on Nov 22 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2013
Added on Nov 22 2013
1 comment
2,549 views