Re: Skipping records with sqlloader
Date: Sat, 9 Dec 2000 08:43:29 +0100
Message-ID: <90sufd$25pot$1_at_ID-62141.news.dfncis.de>
You could try to do the following
Create a view on that table
select * from foo where <column> <= 2100 with check option
The check option of course is here what is doing the trick.
Force loader to insert in that view, and some records will be rejected and
end up in the bad file.
Never done this, but I don't see (as long as you don't load in direct mode)
why it shouldn't work.
Hth,
Sybrand Bakker, Oracle DBA
"Brian Dick" <bdick_at_home.com> wrote in message
news:j59Y5.3362$R62.26526_at_news1.wwck1.ri.home.com...
> My data file contains a field that has values from 1 to 3000. I want to
skip
> records where this field is <= 2100. I looked at using "WHEN" but it seems
> to only accept "=" and "<>" operators.
>
> Later,
> BEDick
>
>
>
Received on Sat Dec 09 2000 - 08:43:29 CET