Suppose we have insert 1000 records into a table .suppose 800th record is not inserted. How can we know that 800th record is not inserted.
Printable View
Suppose we have insert 1000 records into a table .suppose 800th record is not inserted. How can we know that 800th record is not inserted.
[QUOTE=aurobinda.dalai;29324]Suppose we have insert 1000 records into a table .suppose 800th record is not inserted. How can we know that 800th record is not inserted.[/QUOTE]
Which utility are you using?
You can get the details of rejected records, reason for rejection can be found from log file.
if using sql*loader then check the log file as wellas the bad file.