•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 426,310 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,286 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 814 | Replies: 8
 |
•
•
Join Date: Apr 2007
Location: egypt
Posts: 13
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
need help how can i convert an access database to oracle database
please help me
please help me
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
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.
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.
Share your Knowledge.
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation: 
Rep Power: 11
Solved Threads: 235
hi debasisdas, good post. it help me too.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
I am glad that i could help you guys.
Share your Knowledge.
•
•
Join Date: Sep 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
If the database is small u can just copy them,the paste it in the result grid in TOAD also.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
Can You please explain what do you mean by copy the oracle database.
Share your Knowledge.
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation:
Rep Power: 11
Solved Threads: 235
•
•
•
•
Originally Posted by RamyaJayaram 
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.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Sep 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 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
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
•
•
Join Date: Feb 2008
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 2
Newbie Poster
•
•
•
•
Originally Posted by ahmed elweshahy
how can i convert an access database to oracle database
please help me
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.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the Oracle Forum
- Previous Thread: Oracle and EnterpriseDB comparison needed....
- Next Thread: Toad
