Duplicating a Schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Duplicating a Schema

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up


    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
  •  



Click Here to Expand Forum to Full Width