Как вставить массовые данные из SQL в oracle с помощью C# ?
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
Что я уже пробовал:
я сделал это с помощью sql-команды 'insert'