RE: SQL * Loader

If on UNIX, use a wrapper korn shell for the load job. And run following 'egrep' command after the load to extract what you want from the loader log file. Send the output to another file, which can be printed or e-mailed...

 egrep '^Table|Rows|^Total' log.file > load_summary.file

Hope this helps.

• Kirti

> -----Original Message-----
> From: j_shah [SMTP:j_shah_at_frontiersystems.com]
> Sent: Thursday, May 25, 2000 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL * Loader
>
> Hi Gurus,
> At the end of loading I want to provide user with report that x records
> have
> come and out of which y records have been rejected. If you look at .log
> file
> you can get information but I just want to send the summary of rows
> loaded,
> rejected And I want to automate that process. i.e after eahc loadig it
> will
> give me information that abc table was loaded with z records out of x
> records
> in the .dat file with y records rejected. Is there any facility/option in
> SQL*Loader that can be used to report such statistics. Also, is there
> anyother
> way of getting such result automated ??
> Thanks in Advance,
> -- J. Shah
>
> --
> Author: j_shah
> INET: j_shah_at_frontiersystems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri May 26 2000 - 07:57:33 CDT