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.
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.