 question about access & oracle [message #339975] |
Sun, 10 August 2008 11:02  |
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  |
 |
Littlefoot
Messages: 21809
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
