Updating an Oracle Table from SQLServer

From: mike <hillmw_at_charter.net>
Date: 22 Mar 2005 09:51:09 -0800
Message-ID: <1111513869.415407.163220@o13g2000cwo.googlegroups.com>

I have this SqlServer table and need a portion of that data in my Oracle Table. This movement of data happens weekly.

I have this process for doing that. Here is some pseudocode of the process that I am employing:

Select the data from the SqlServer.
  Loop over the SqlServer result set.
    Query the Oracle table to see if the key exits.     If the key exists

         Execute a Update Statement to Oracle Table
       Else
         Execute an Insert Statement to the Oracle Table

    End IF
  End Loop

I am looping over 44k records.

Anyone have any other ideas that i should look into?

Mike Received on Tue Mar 22 2005 - 11:51:09 CST