copy million rows in oracle

[b_pati]

Hi,
My requirement is to copy million rows in a table from the server database to the client database using vb.net in windows application. My database is in oracle. presently copying is taking me around 1 hr i need to reduce the time what is the best way to achieve this using vb.net code

My server database is oracle 11i and in the client machine i have oracle 10g installed

Thanks in advance

 

[jmcilhinney]

Unless you're actually displaying the data in a form, this question has nothing to do with WinForms. Thread moved.

There's no point your bringing the data into your app. You should execute a SQL statement on the client database and have it get the data from the server database directly. I don't know the exact Oracle syntax but in SQL Server it would be something like:

INSERT Table1 (Column1, Column2)
SELECT (Column1, Column2)
FROM Server.Database.Table1

 

[b_pati]

Hi jmcilhinney,
Thanks for the SQl command.
I have to execute the SQL command through my application only because
only after running my application setup the client(the Machine i installed my app) will know the server connectivity .

and running from my application is taking me longer time.

 

[jmcilhinney]

There's no way that we can tell you what you're doing wrong if we don't know what you're doing.

 

[cjard]

You shouldnt be involving your VB app in this at all; it will be way too slow and a dumb idea to download a million rows into a low spec desktop when you can jsut have the servers transfer it between themselves

Oracle Data Replication and Integration