DSXchange

hi guys
i have reqirement like this ...........
source is Complex Flat File
Target is Oracle OCI BULK
when i load the data from Flat file to Oraoci Bulk four record are loaded
but when i check the data in Target no records found
same job iam using oracle normal data loaded 4 records& viewing thw data .wht is the probs with orabulk

Look for the "bad file" generated by sqlldr.

i checked the log in file in oracle its creating some data but in some procedurs or not running..............

seshikumar wrote:i checked the log in file in oracle its creating some data but in some procedurs or not running..............

..not quite sure what you mean here....

...but some questions?

• Does the job say it has completed successfully when you use Bulk Load? i.e. check in Director. Are there warnings?
  As Ray said check the .log and .bad files that are created by the Oracle Bulk Load process.