I m trying to insert data from table in SQL Database to other tables in oracle database column names are differents. i want to know if there is a methode to perform my code in c# , to insert into tables in oracle database. I am trying to insert 100000 records. my target is that this insert takes less than 3hours. i m not allowed to use procedures i cant access source table from destination tables database and viceversa both tables dont have any indices how can i minimize this time? can i use oracle bulk insert and how? i tried to search oracle bulk insert but it requires some Oracle.DataAccess.Client namespace i dont have it
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip