question about access & oracle [message #339975] |
Sun, 10 August 2008 11:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
EL-SAYED
Messages: 17 Registered: July 2008
|
Junior Member |
|
|
dear all :
how can i transfer my access database to oracle
in other worlds
i want to transfer the tables and its data to tables in oracle without use create table and insert into .
thanks
|
|
|
|
Re: question about access & oracle [message #339987 is a reply to message #339975] |
Sun, 10 August 2008 14:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You might take a look at Oracle's Heterogeneous Services. Or, the most straightforward way, create a CSV file in MS Access and load it into an Oracle table using SQL*Loader (or via external tables feature (offered from 10g onwards)).
P.S. Why did you ask this question in the Forms forum? I'll move it to Server Utilities; if you feel that it should be somewhere else, please, report it to a moderator and - if you provide a valid explanation - it will be moved again.
[Updated on: Sun, 10 August 2008 15:02] Report message to a moderator
|
|
|