oracle [message #21127] |
Mon, 15 July 2002 07:22 |
rajat garg
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
can we change any other database like MS Access,SQL Server or any other data base in oracle directly.
as if we r having any table in MS access can we change that table directly in ORACLE table by writing a code or any other method.
|
|
|
Re: oracle [message #21137 is a reply to message #21127] |
Mon, 15 July 2002 20:53 |
Rohit Mehrotra
Messages: 9 Registered: July 2002
|
Junior Member |
|
|
Yes Tht Can be done.
U will have to create a dsn which can connect to ur oracle server.
Now in MS Access Use Save As/Export Option To export tht file in oracle..
Rohit
|
|
|
Re: oracle [message #21165 is a reply to message #21127] |
Tue, 16 July 2002 16:53 |
Alex
Messages: 190 Registered: August 1999
|
Senior Member |
|
|
Oracle has a tool named migration workbench. It can do such a work.
You can also save the table contents into a plain text file and use sql*loader to load it into the oracle database.
|
|
|