Bulk insert from asp.net 2005 to oracle

[montu3377]

Hi, I have to insert 200,000 rows from datatable (from asp.net 2005 webform(vb.net 2005 code behind ) to oracle 10g table.Here if i insert this by row by row then it will not work,so i need some bulk insert from asp.net to oracle. can anybody suggest some good way to do it.Here we need to take care that as rows are too much large so server or client should not hang. If some code/link is available then it could be helpful to me. thanks montu3377

[Vikram kshatriya]

Hi , Please refer to SqlBulkCopy class in .NET 2.0.I have used this class to insert 1000 rows from ASP.NET to SQL SERVER 2005.I do not know whether it can be used with Oracle or not.So please find out if this class is helpful to you. Thanks, vicky

Vicky

[Arindam Tewary]

I guess SQLLoader in Oracle 9i is the best option for bulk data insertion. Arindam

[montu3377]

Hi, To insert 200,000 records into oracle it's taking around 10 mints time by using Sql loader utility method,so can you pls. suggest some good method which insert records very quickly. I am using .csv file which containts around 200,000 records.I want to insert that records from asp.net to oracle 10g. Can you pls. suggest better way to do it. thanks. montu3377