Number of rows loaded via sqlldr

Shell Programming and Scripting
1

Hi all,
I'm loading data in database through sqlldr.
I want to know the total record count
And the number of records inserted in table..
what is the logic to achieve that.

Thanks

2

just add "log=load.log" in your sqlldr command.
inside log file you will come to know how many records inserted and how many records rejected due to errors.

3

Actually I don't want full log file
I just want the records loaded n number of records rejected

4

you have option bad=badfile.log to your sqlldr command.

you can do

cat badfile.log | wc -l

to get rejected records.

You can do

cat  file.csv | wc -l

to get total records

total records - rejected records = records inserted.

OR

query the table ( select count(*) from table_name) on which you are inserting data to get total inserted records

OR
inserted records

awk ' /Rows successfully loaded/ {print $1}' sqlldr.log

rejected records

awk ' /Rows not loaded due to data errors/ {print $1}' sqlldr.log
5

Hi,

I have text file as EG.txt

the file content is like:

CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12
CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12
CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12

when i do /cat AE.txt | wc -l
it displays 2 instead of 3..

Any idea why its showing (number of rows - 1)

6

You have 30 posts now. By now you should be aware that :

  • always use code tags to post your data.
  • create a new thread for new topic.

About your question, please make sure you don't have any blank line in the file.

1 Like