SQL*Loader -605:Non-data dependent ORACLE error occurred

sudhakar_viswa · Post by **sudhakar_viswa** » 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

ArndW · Post by **ArndW** » Thu Aug 31, 2006 2:36 am

It sounds as if you have a commit frequency of 1000 or a smaller number that divides evenly into 1000. Oh, wait - you are using the bulk loader? This is particularly fast because it doesn't care about rollback or constraints, so you can't back out.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 31, 2006 3:12 am

Get the tablespace increased and/or made dynamic. There's nothing you can do in DataStage to overcome "tablespace full" in Oracle.

sudhakar_viswa · Post by **sudhakar_viswa** » Thu Aug 31, 2006 3:43 am

Hi,

Thanks for reply.

I am not using bulk loader.
I don't want to load the records if job gets aborted due to any reason.

Thanks & Regards,
--sudhakar

ArndW · Post by **ArndW** » Thu Aug 31, 2006 4:24 am

If you are not using the bulk loader, then check what your commit frequency is.