File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Data Trafer one DB to anothert Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Data Trafer one DB to anothert" Watch "Data Trafer one DB to anothert" New topic

Data Trafer one DB to anothert

Aamir Memon

Joined: Jul 05, 2001
Posts: 7
How can I transfer the whole schema in Oracle using Java from one machine to another.....
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
Generally I am using a modeling tool before creating the database, so I can use its scripting tool to create the DDL which creates the database. So I am unused to doing what you are trying. You can pull the statements from the various system tables but that will be a lot of hassle.
What I suggest is use a modeling tool. They enable you to look at a database, and create a model from it. You can then create the script from that model to create the new database.
Mohamed Yousuff
Ranch Hand

Joined: Jun 23, 2001
Posts: 73

You just want to transfer oracle schema from one machine to another. I could not understand why you want it through java. Oracle provides an export schema tool which will do the entire stuff perfectly. Check oracle documentation for details on this.
I agree. Here's the link:
subject: Data Trafer one DB to anothert
It's not a secret anymore!