Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External tables - rejected rows
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