• Post Reply Bookmark Topic Watch Topic
  • New Topic

Data Trafer one DB to anothert

 
Aamir Memon
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can I transfer the whole schema in Oracle using Java from one machine to another.....
Regards
 
Daniel Dunleavy
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
------------------
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!