Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/247750

From BetaArchive Wiki
Knowledge Base

BUG: Table Names Enclosed in Double Quotes When Transferred from SQL Server to Oracle

Article ID: 247750

Article Last Modified on 2/24/2004


  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q247750

BUG #: 56517 (SQLBUG_70)


When table(s) are transferred from SQL Server 7.0 to Oracle7.x or Oracle 8.x using the Microsoft OLE-DB Provider for Oracle in Data Transformation Services (DTS), they are enclosed in double quotes when created in Oracle.


Query the table(s) using quotes in Oracle.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: kbbug oracle

Keywords: kbbug kbpending KB247750