Hiii guys,
I tried to insert data into the oracle table using oracle enterprise stage. I used both Upsert and Load method. When I use the Upsert method the data gets loaded and the job runs fine but when I run the job using the Load method with index mode rebuild, the job dosen't abort but the data is not getting loaded. When i checked the director log,
"XXX": Index `SYSADM.xxx' on table `sysadm.xxx' has been rebuilt.
"xxx"; status: VALID.
where xxx is the table name
When i added a reject link, i can capture those records. Can anyone shed some light on this...or at least a way to approach this problem?
oracle enterprise stage load error
Moderators: chulett, rschirm, roy
oracle enterprise stage load error
Last edited by gsym on Thu Jan 29, 2009 8:16 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It actually a parallel job
its actually a parallel job.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore