error during data migration from oracle to SQL server 2005 using linked server

• joyforrippu

  Newbie

  Points: 7

  More actions

  April 3, 2008 at 7:23 am

  #188687

  Hi!

  I need to transfer data from oracle to SQL server 2005. I've used linked server for it as I can easily map CLOB datas to TEXT data types. But I am facing the following error.

  The OLE DB provider "MSDAORA" for linked server "ORALINKSERVER" returned a "NON-CLUSTERED and NOT INTEGRATED" index "PK_TEST_ID" with the incorrect bookmark ordinal 0.

  How to get rid of this error.

  Also where can I check the permissions for the tables in linked server.

  Please help. Its really important.

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 3, 2008 at 7:39 am

  #797807

  I would suggest using the Oracle Ole provider as you are less likely to run into translation errors.