Oracle rejects
Posted: Mon Nov 28, 2005 11:14 am
Hi All,
I have file having 276 records after some cleaning , total valid records are
270 and those should be inserted or rejects should be caught in the reject
file , but i see 270 going to ora oci table link and 0 records to reject link.
and 263 records are there in the target table , i am not able to understand
what happened to 7 records .
but for other file i have 100 recs and 99 got inserted and 1 record got rejected.
could some one help me what could be the reason?
any help greatly appreciated.
Thank you all
I have file having 276 records after some cleaning , total valid records are
270 and those should be inserted or rejects should be caught in the reject
file , but i see 270 going to ora oci table link and 0 records to reject link.
and 263 records are there in the target table , i am not able to understand
what happened to 7 records .
but for other file i have 100 recs and 99 got inserted and 1 record got rejected.
could some one help me what could be the reason?
any help greatly appreciated.
Thank you all