Bulk loading of data from source to target
Posted: Thu Jan 31, 2008 12:30 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.
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.