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
SQL*Loader -605:Non-data dependent ORACLE error occurred
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
SQL*Loader -605:Non-data dependent ORACLE error occurred
i need to know datastage
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
If you are not using the bulk loader, then check what your commit frequency is.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>