DTS between SQL server 2000 and Oracle 8.1.7

2013-06-07  Source: Original Site  Category:Microsoft SQL Server  Views:0 

Advertisement

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?

Related articles