how can i convert an access database to oracle database
please help me
ahmed elweshahy -4 Newbie Poster
debasisdas 580 Posting Genius Featured Poster
You can't convert directly. But you can upload data of access into oracle.
You can export the data of access into a .CSV file and from oralce use the SQL LOADER to load the same data to oracle table.
Jx_Man 987 Nearly a Senior Poster Featured Poster
hi debasisdas, good post. it help me too.
debasisdas 580 Posting Genius Featured Poster
I am glad that i could help you guys.
RamyaJayaram 0 Newbie Poster
If the database is small u can just copy them,the paste it in the result grid in TOAD also.
debasisdas 580 Posting Genius Featured Poster
Can You please explain what do you mean by copy the oracle database.
Jx_Man 987 Nearly a Senior Poster Featured Poster
If the database is small u can just copy them,the paste it in the result grid in TOAD also.
I m not understand friend... Please explain more detail about the copied one.
RamyaJayaram 0 Newbie Poster
Hi I have tried this @ critical times,
These were the steps I use to do
1.Select the few rows from access DB u want to copy to Oracle
2.Run the following query in oracle
Select * from table_name where rownum<5 for update;
3.We can see an extra line added to the result set grid at its end,click on the first column,so the whole row gets selected and paste the access records.
Hope i have shared wat i know.Thanks
kevs1607 0 Newbie Poster
how can i convert an access database to oracle database
please help me
you can use this software "acc2orad".
but problem with this software is that coversion is limited with only 5 rows of each table.
Another option is u need to migrate your access database into oracle with facility of oracle.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.