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?
that means we want to create a clone schema in database in another server.
What are the steps for that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
When using data pump, you can remap tablespace name, schema names etc, therefore basically you are preparing copy of schema for some use.
ASKER
Good solution..
For Unix
http://www.dba-oracle.com/oracle_tips_db_copy.htm
For Linux
http://www.oracle-base.com/articles/misc/manually-cloning-an-existing-oracle-db-installation-on-linux.php