January 12, 2011 at 4:12 pm
i am trying to access a oracle table where the data is around 800,000 records. i need to update my sql table which has around 2000 records from a column in oracle.
since the data is too much in oracle; not sure how to go about it.
January 12, 2011 at 4:34 pm
What is your actual concern ?
Thank You,
Best Regards,
SQLBuddy
January 12, 2011 at 5:56 pm
it takes long time..i want to know if there is method i can use to make it faster.
January 12, 2011 at 10:32 pm
It's not exactly clear what you are trying to do.
Are you trying to update your 2000 SQL Server records based on values from the oracle table?
Or are you trying to extract 800,000 records from a column in an oracle table and insert them into a sql table which has one column? Thus you end up with a sql table with a single column and 802,000 rows?
How long is it taking?
Which side of the process is taking the longest?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply