wood burning stoves 2.0
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: http://aspose.com/file-tools
subject: Data Trafer one DB to anothert
It's not a secret anymore!