Results 1 to 3 of 3

Thread: Export problems

  1. #1
    Join Date
    Jul 2007
    Posts
    4

    Smile Unanswered: Export problems

    Hi,
    I have ecountered the following error during export from sql sever using odbc to oracle database.

    sql server ==> export ==> oracle database

    error msg : query cannot be updated because it contains no searchable columns to use as a key.

    Anyone can help. Thanks in advance

  2. #2
    Join Date
    Jul 2007
    Posts
    7
    add a temporary identity colum to your table before you export...

  3. #3
    Join Date
    Jul 2007
    Posts
    4

    Export problems

    Hi, xoqon

    sorry I don't really understand what you means? for example the export table is as:
    txn_table (txn_id int) --> temp_table(txn_id number) <oracle>

    thanks

    >> add a temporary identity colum to your table before you export...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •