| exporting data from sql server or access to oracle [message #67777] |
Fri, 08 March 2002 13:27  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
