Hello Mike,

The name is Rashi. It was quite the chore to get your oracle db replication script to work, and i'm still having OCI problems with Oracle 10g. Anyways, after about 30+ hours of banging my head on the wall, I have been able to get the 'sql' file containing the all the objects. Now comes the challenge to load data into these tables.

Could you share some of the 'sql*loader' scripts and talk about the challenges you and the dba faced in loading data? It would be very well appreciated.

I extracted data from sfdc using data loader - accounts object/table. Using Oracle10g's web interface, I tried loading the data into the db [accounts table] and got errors on data size, which ofcourse on manual checking looks fine. I then tried to use sql*developer's excel import facility to load data which also has given me a high percentage of load errors. I am hoping that with insight that you may be able to provide with the sql*loader scripts, I can get all the data into the oracle tables successfully.

Thank You.
Rashi