Using the Discard FIle with External Tables
819570Mar 9 2012 — edited Mar 13 2012Hi,
We're using Oracle 11.2.
We want to create an External Table to read in a composite date file.
This file has 4 different types of rows. We want to read in only the lines that begin with the number"4".
The other three lines we want to discard. I know there's a provision in SQL LDR that lets you skip lines in your data file when they contain or don't contain certain key values and those lines get sent to the discard file.
I thought I could use the "REJECT ROWS WITH......" clause but apparently that's only used for" REJECT ROWS WITH ALL NULL FIELDS" and there is no other way to use that it seems.
How do you do this in an External table?