Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    new jersey
    Posts
    4

    Unanswered: DTS between SQL server 2000 and Oracle 8.1.7

    Hi,

    I used DTS Export Wizard to copy tables from SQL server 2000 to Oracle 8.1.7. After transfering completed successfully, I loged into oracle and tried to select data from the tables. I got 'table does not exist' error. But when I select table_name from oracle data dictionary, I saw tables exist in oracle. Then I opened SQL Query Analyzer, I can select data from the tables just transfered through linked oracle server.

    Does anyone have same experience? Could someone please give me suggestion?

    Thanks in advance!

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: DTS between SQL server 2000 and Oracle 8.1.7

    Before you started the DTS transfer, did you define the table in the tablespace you want it to be? If you just let DTS create the table, chances are it's in System.

  3. #3
    Join Date
    Feb 2004
    Location
    new jersey
    Posts
    4

    Re: DTS between SQL server 2000 and Oracle 8.1.7

    Originally posted by joejcheng
    Before you started the DTS transfer, did you define the table in the tablespace you want it to be? If you just let DTS create the table, chances are it's in System.

    I defined the oracle schema before I started DTS transfer. The tables are in right schema and right tablespace. I also tried to drop those table, but I can't drop in oracle.

    Thanks,

    Lucy

  4. #4
    Join Date
    Feb 2004
    Location
    new jersey
    Posts
    4

    Re: DTS between SQL server 2000 and Oracle 8.1.7

    Originally posted by llin
    I defined the oracle schema before I started DTS transfer. The tables are in right schema and right tablespace. I also tried to drop those table, but I can't drop in oracle.

    Thanks,

    Lucy
    I found I have to put double quote around table to select data in oracle.

    select * from "friends";

    Lucy

  5. #5
    Join Date
    Jan 2004
    Location
    Ottawa, Canada
    Posts
    53
    The table names in Oracle are case sensitive.

    This may be your problem. Try the statement in UPPER case and in camelCase.

    Good luck

Posting Permissions

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