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
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
