data loading problem in oracle bulk

seshikumar · Post by **seshikumar** » Mon Oct 08, 2007 2:19 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Oct 08, 2007 4:35 am

Look for the "bad file" generated by sqlldr.

seshikumar · Post by **seshikumar** » Mon Oct 08, 2007 10:10 am

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

nick.bond · Post by **nick.bond** » Mon Oct 08, 2007 10:40 am

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.