Link to home
Start Free TrialLog in
Avatar of tonydba
tonydba

asked on

to clone schema

What are the steps to clone a schema..
that means we want to create a clone schema in database in another server.

What are the steps for that?
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wasimibm,

Original post is to clone a schema, not a database.  The 2 links that you posted are for cloning an entire database.  By the way, either method would work on both Unix and Linux.
You can use expdp/impdp to take backup of particular schema and import in same/different database as needed. Lets say you want Prod data in Dev environment and schema names are different accross databases. I mean Prod schema name is ProdAppUser and Dev has DevAppUser etc,
When using data pump, you can remap tablespace name, schema names etc, therefore basically you are preparing copy of schema for some use.
Avatar of tonydba
tonydba

ASKER

Good solution..