-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|