Bulk loading of data from source to target

harish_s_ampeo · Post by **harish_s_ampeo** » Mon Feb 04, 2008 2:57 am

I have the source data.I have to load the complete data from source to target using the bulk load(manual).Everytime when we load, the previous data should be delete and then enter the complete new data.Using bulk load manual strategy I have to delete and insert the data into oracle table.

For this I have used two scenarios

1. I have used Oracle 7 Load. This one will replace the existing data with new data.This will create two files .ctl and .dat.The data is coming into the .dat file but i am unable to load the data into the ORACLE table.How to load the data from .dat file into the oracle table?

2. I have used Oracle OCI Load (8.1).In this I deleted the data from before job sub-routing ExecSH command.But the data should not be deleted until the new data comes.This will create two files .ctl and .dat.The data is coming into the .dat file but i am unable to load the data into the ORACLE table.How to load the data from .dat file into the oracle table?

Please help me regarding this.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 04, 2008 3:43 am

Try Search - you are not the first to want to do this. The OCI 8 Load stage simply invokes sqlldr so please check whether you have automatic execution disabled. Find out from whoever created the job why it is set as it is before attempting to change anything - this reason really should be documented somewhere in the job.

chulett · Post by **chulett** » Mon Feb 04, 2008 8:28 am

You posted this exact same question last Wednesday. Why do you feel the need to post it again?

If you have a problem with the answers posted so far, say so. In the other post.