Recreate database schema on another system?

Use exp to export it, and imp to import it.

Would futher recommend expdp and impdp if the version(s) of Oracle are recent enough. Much better tools. – Adam Hawkes Oct 25 '10 at 17:11 @Adam, you are correct in general, but OP stated the transfer is for the schema only, no data, so it's likely a wash performance-wise.

Also, with expdp, the dump file is created ON THE SERVER, so you need access to the server to get at your dump file, and put it on your local server to use impdp. In this way it can be less convenient, since exp/imp are client-side utilities. – DCookie Oct 25 '10 at 17:20.

As Paul stated, use exp/imp to perform the operation. As for your question concerning different DB versions, yes, this is a possible concern. I assume you're copying the schema from an older version to a newer one?

Make sure you use the exp utility for the older database, as imp is backward compatible. You might run into problems trying to go from a newer version to an older one, as you'd have to use the exp utility from the older version on the newer DB, and that might be problematic.

As stated, exp/imp will work and these should already be on your machine. I just wanted to add that if you use any third party tools (for example, I use TOAD) your tool might contain some common operations such as "Compare Schemas" or "Create Sync Script" etc.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.