It's not a secret anymore!
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
Author

Data Trafer one DB to anothert

Aamir Memon
Greenhorn

Joined: Jul 05, 2001
Posts: 7
How can I transfer the whole schema in Oracle using Java from one machine to another.....
Regards
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.
Dan
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!