Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 export tables

Author  Topic 

saikrishnapotluri
Starting Member

1 Post

Posted - 2001-08-02 : 01:16:28
When I use the option of export to export the tables from SQL SERVER to personal oracle I have selected the driver as MICROSOFT ODBC FOR ORACLE and exported the tables to oracle with user name scott and passowrd as tiger .After the execution of the wizard when I gave the oracle command select * from tab it is displaying all the tables which have been exported but when I issue an DML command like select it is giving an error message table or view does not exist.Can you please help me out in this problem.
   

- Advertisement -