Re: External tables - rejected rows

"gazzag" <gareth_at_jamms.org> wrote in message news:1149153088.800271.211870_at_u72g2000cwu.googlegroups.com...
: Mark C. Stock wrote:
: > rejected rows are not expsed via the external table, because they were,
: > well, rejected.
:
: Perhaps I'm not making myself clear. I'll try again:
:
: The number of rows rejected during the insert = (total number of rows
: in the external table) MINUS (sql%rowcount after the insert)
:
: In other words, knowing how many rows are in the external table (select
: count(*) into external_table_rowcount from <external_table>;), together
: with the number of rows inserted (sql%rowcount), it is quite easy to
: calculate how many rows were rejected during the insert.
:

you're clear, but i believe you're looking at the wrong operation

IIUC, the OP was referring to the rejects that occur during the loading of the external table (which end up in the bad file) -- there's really no such thing as rejects from an insert (although there is an exceptions collection for bulk inserts -- not part of this thread yet)

++ mcs Received on Thu Jun 01 2006 - 05:39:32 CDT