SQL*Loader -605:Non-data dependent ORACLE error occurred
Posted: Thu Aug 31, 2006 2:18 am
Hi,
I got the following error.
SQL*Loader -605:Non-data dependent ORACLE error occurred.
I found the solution , there is no space in table to load the records.
The problem is, we are processing 100,000 records.After 1000 records job got aborted.So,the records should get rollback.But it is not happening.It loaded 1000 records into target.I don't want to load any single record if job gets aborted.
My target is oracle 9i.
i am using data stage parallel edition.
can anybody help me out.
thanks & regards,
--sudhakar
I got the following error.
SQL*Loader -605:Non-data dependent ORACLE error occurred.
I found the solution , there is no space in table to load the records.
The problem is, we are processing 100,000 records.After 1000 records job got aborted.So,the records should get rollback.But it is not happening.It loaded 1000 records into target.I don't want to load any single record if job gets aborted.
My target is oracle 9i.
i am using data stage parallel edition.
can anybody help me out.
thanks & regards,
--sudhakar