Home » RDBMS Server » Server Utilities » Export Data from SQL Server to Oracle 9i Database
Export Data from SQL Server to Oracle 9i Database [message #148192] Wed, 23 November 2005 00:55 Go to next message
mian imran
Messages: 29
Registered: July 2004
Junior Member
i have export data from SQL Server (DTS Utility) to Oracle Database 9i. The tables and data expoerted successfully but when i describe table or select data from table it does not show any thing but error like
ERROR at line 1:
ORA-00942: table or view does not exist

and

ERROR:
ORA-04043: object users does not exist

but at the same time when i check data from OEM (Oracle Enterprize manager )it shows data and also structure. it also show data on reports.
pleae define what is a proboelm with Forms and Sqlplus not showing data and table structure??

Report message to a moderator

Re: Export Data from SQL Server to Oracle 9i Database [message #148372 is a reply to message #148192] Wed, 23 November 2005 17:45 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The tables on SQL Server are probably in mixed case.

Try double-quoting the table name:

SELECT * FROM "MyTable"


_____________
Ross Leishman

Report message to a moderator

Previous Topic: EXPORT/IMPORT
Next Topic: How to install and use 8.1.7 export utility on 9.2 server ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 05:19:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.