Hi,
How do I create an Exact Replica of a Schema with all its objects, grants extra in the same database but with a different schema name.
Please Suggest
Ronnie
Printable View
Hi,
How do I create an Exact Replica of a Schema with all its objects, grants extra in the same database but with a different schema name.
Please Suggest
Ronnie
Create the new schema (name, tablespace, datafile, whatever). Export the schema you want to copy with grants=Y, and any other parameters you would like. Import that .dmp file into your NEW schema. Be sure to use FROMUSER=OLD_SCHEMA TOUSER=NEW_SCHEMA and also use grants=Y and any other parameters you would like (rows=Y, etc.).
Enjoy!
- Magnus