Monday, March 19, 2012

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!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.|||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|||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|||The table names in Oracle are case sensitive.

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

Good luck

No comments:

Post a Comment