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!

How to reject record in sqlldr

OraFighterMay 19 2014 — edited May 23 2014

I need to reject the records if its length is less than 5 or greater than 15 .

Is it possible in SQLLDR to reject records while loading data.

COL1

ABCDEFGH

ABCD -Reject this record

AB -Reject this record

LKSDJFLLSDLKDSDFSDSD -Reject this record

KKKLLLLLLLK

please help..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2014

Added on May 19 2014

#database-key-features, #export-import-sql-loader-external-tables

16 comments

7,071 views