partition question
Posted: Sun Aug 02, 2009 9:19 pm
Hi,
I have a simple job which reads from a file and updates a particular field in a oracle database.
The file has around 20 mil record and the commit count is 10000. The partition type is Auto(havent changed anything).
Now the job aborted in the middle due to oracle instance being down. It had updated around 12 mil records.
Now if we re-run this again all the 20 mil records would be taken for update. But since the partition is Auto, we are not sure whether the updated records are the first 12 mil records from the file which we can remove and run this job again with just remaining 8 mil records.
Can anyone comment on this.
I have a simple job which reads from a file and updates a particular field in a oracle database.
The file has around 20 mil record and the commit count is 10000. The partition type is Auto(havent changed anything).
Now the job aborted in the middle due to oracle instance being down. It had updated around 12 mil records.
Now if we re-run this again all the 20 mil records would be taken for update. But since the partition is Auto, we are not sure whether the updated records are the first 12 mil records from the file which we can remove and run this job again with just remaining 8 mil records.
Can anyone comment on this.