oracle enterprise stage load error
Posted: Thu Jan 29, 2009 12:17 am
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?
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?