CODEWITHSUNDEEP
sqldatabaseoracle-databaseschema
Epitaph
Epitaph

Reputation: 3148

Recreate database schema on another system?

I have access to a remote Oracle database with a schema consisting of may tables but no data. I'd like to recreate this schema on my local database system for testing purpose. How would I go about this? Are there any utilities that can help with this?

Also, if the 2 Oracle database versions are different would that be a cause of any concern?

Upvotes: 0

Views: 561

Answers (3)

wweicker
wweicker

Reputation: 4962

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.

Upvotes: 0

DCookie
DCookie

Reputation: 43533

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.

Upvotes: 1

Paul Tomblin
Paul Tomblin

Reputation: 182850

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

Upvotes: 2

Related Questions