Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Unanswered: ORA-01740 error on DTS export

    Hi everyone,

    I am getting some errors while trying to export data from SQL Server tables to Oracle tables. The one particular one is ORA-01740 (Missing double quote in identifiers). I am getting it on tables that have all NUMBER fields also. Is this a known issue. How can I work around this error?

    Thanks,
    Pankaj

  2. #2
    Join Date
    Dec 2003
    Posts
    3

    ORA-01740 and DTS

    Hi,

    I had the same issue recently. I found that maximum length of the target Oracle table could not exceed 21 characters. As soon as I kept my table names to this limit - everything went in nicely.

Posting Permissions

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