Post reply

exporting data from Sql server 2000 t oracle using DTS in sql

  • May 21, 2008 at 6:31 am

    #185819

    i am trying to export data from sql server 2000 to oracle8i using DTS.

    it doing the process properly but not able to get the data at

    sql prompt

    ur help is appreciated

    thx in advance

  • May 21, 2008 at 9:13 am

    #818642

    Please give us more information. What is the process? How do you know it's working properly? What does, "not able to get the data at sql prompt" mean?

    Greg

  • June 12, 2008 at 5:24 am

    #827751

    hi

    i am exporting the data from sql 2000 to oracle 8i the DTS shows its successful.

    but after logging on to oracle client and try find out data in table or even u try to desc tables that shows an error msg saying object does not exist

    but if fire a query select 8 from tab; shows all tables in the database

    what is wrong with that??

    bye

  • June 27, 2008 at 1:57 am

    #835194

    Most probably the problem is that DTS is creating case sensitive table names, but if you fire select in Oracle without double qoutes it assumes table names are in uppercase.

    So if you have table TableName in SQLServer it creates exactly the same table names in Oracle and you should query them as follows:

    select * from "TableName" using double quotes around table name.

    Gints Plivna

    http://www.gplivna.eu

    Gints Plivna
    http://www.gplivna.eu

Viewing 4 posts - 1 through 3 (of 3 total)

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