Home » RDBMS Server » Enterprise Manager » exporting data from sql server or access to oracle
exporting data from sql server or access to oracle [message #67777] Fri, 08 March 2002 13:27 Go to next message
Amit
Messages: 166
Registered: February 1999
Senior Member
I have used DTS to export data to oracle.I can see those exported table but when i try to access it say "table not exist".
Can anyone tell me what is the problem or how will i export data to oracle 8i from access or sql server.

Thanx in advance
Re: exporting data from sql server or access to oracle [message #67793 is a reply to message #67777] Wed, 20 March 2002 18:15 Go to previous messageGo to next message
Dinesh
Messages: 31
Registered: October 2001
Member
Hi Amit,
I hope that all the tables got transfer to oracle by DTS import/export wizard from any database to any database.
But to transfer the tables into oracle.u hv to make table name into uppercase and then u transfer the tables into oracle by using DTS.
This applicable for Access and SQl server also

Bye
Dinesh
Re: exporting data from sql server or access to oracle [message #68547 is a reply to message #67777] Tue, 10 February 2004 15:32 Go to previous message
JERALD
Messages: 3
Registered: June 2002
Junior Member
use double quotes around table name.

Ex : select * from "student"
Previous Topic: OEM-OMS does not recognize database self
Next Topic: command to create mount points
Goto Forum:
  


Current Time: Thu Mar 28 17:24:29 CDT 2024