Re: External tables - rejected rows

From: Anurag Varma <avoracle_at_gmail.com>
Date: 31 May 2006 09:40:10 -0700
Message-ID: <1149093610.064931.208530@c74g2000cwc.googlegroups.com>

Chuck wrote:
> I'm loading data into a table by inserting rows from an external table.
> I can easily determine the number of rows inserted in pl/sql by looking
> at the sql%rowcount attribute after the insert completes. Is there a way
> to easily get the # of rejected rows in pl/sql?
>
> Thanks

The rejected rows will be placed in a .bad file. You can create an external table (with column definitions like varchar2(4000) so that you can query it) and do a count(*) on it. Or you can probably create an external table on the log file and query that.

Anurag Received on Wed May 31 2006 - 11:40:10 CDT