This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Tranporting data from Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Tranporting data from Oracle" Watch "Tranporting data from Oracle" New topic
Author

Tranporting data from Oracle

Amar Deep Singh Chaudhary
Ranch Hand

Joined: Dec 26, 2006
Posts: 49
hello everybody

Dear friends i have a database in oracle 9i in my pc.Iwant to transport this data to another machine how i can do it.where the oracle engine stores the data tell me the path. and how i can bring this data so that it works fine on another machine where i need to place that data.And is it necessary that the Oracle should be installed on that machine or we can combine that data with another database.please give a full description to me.


thanks


AMARDEEP CHAUDHARY

"a thinking mind never dies"


"A thinking mind never dies"
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32507
    
214

Amardeep,
The easiest way to move data is to export it and then import it into the new database. If the target database is Oracle, you can use an Oracle export. If the target database is not Oracle, you can export in CSV (comma delimitted) format. In this case, the table needs to exist in the target database.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
Have you checked out Aspose?
 
subject: Tranporting data from Oracle
 
It's not a secret anymore!