Post reply

Linked Server Issue

  • September 25, 2006 at 2:02 pm

    #62431

    I have a link server from SQL Server 2000 Standard Edition SP3 running on Windows 2000 SP4 to Oracle 9i. Selecting Oracle data works fine using the OPENQUERY. However, inserting data from SQL Server into Oracle errors with out of memory issue. The statement is similar to:

    INSERT INTO ORACLE_LINK..DDPCS.EWF_SERVERS

    SELECT COLUMN1, COLUMN2, COLUMN3 FROM SQL_SERVER_TABLE

    WHERE DATE_COLUMN > '06-02-2006'

    AND DATE_COLUMN <= '06-04-2006' Is there something wrong with this code? Is there a better way to write this? Is there something within SQL Server that I may tune to make the code work more efficiently?

  • September 26, 2006 at 8:37 am

    #662485

    We used to get out of memory errors on a linked server to Oracle until I added a startup parameter to SQL Server.  See Books on Line topic "Using Startup Options" especially the -g parameter.  You may want to start with using -g256 but you'll need to stop & restart SQL Server for it to take effect.  Setting this option depends on how much memory you have on the server so only try small increases.  This solved our problem.  Good luck.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply