I build my project on Oracle 9i. Programing language is JAVA. It is a LAN based project. Now i want to change my database from oracle to access because i cant transfer my projectfrom a network to other network. export/import command is also not working in my system. Is there any command to do this either in oracle or access, or is tere any tool avilable in market? Please help me.
Ya there are quiet a few softwares available.You can search them in google but many of them are shareware so you can have a trial version. But i think oracle is a better choice over ms access as it provides more security features and robustness. May i know whats the problem with that imp/exp command. Try exporting in some removable media instead of hard drive.
hi.. this post is quite old. have you found the solution. if not,i suggest u set up ODBC connection at windows control panel (setting connection p pracle database). then call it (import / pull data) from access (ODBC will act as 'middleman')
You can try searching for and using a tool called DataVis, a data migration tool which can probably help you transfer oracle contents into ms access.
I have opposite target: how to transfer my beautiful MSA db to Oracle It's very likely that in few years Windows is going to die or at least it will be a shame for adult to still use it. That's why I'm here: to learn real stuff