Need to Copy Schema to Prod
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Need to Copy Schema to Prod

  1. #1
    Join Date
    Oct 2007
    Posts
    31

    Need to Copy Schema to Prod

    Hi,

    I am running Oracle 10.2.0.3 on Suns 10. I need to copy a schema (not the data) from the development database to the production database. The schema does not exist in production. How can I accomplish this task?.


    Thanks,

    Lucky.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    while exporting use CONTENT=METADATA_ONLY option. Before importing pre-create the user in the production database.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    You might want to check the tablespaces for all that users objects first, if the tablespaces do not exist in your target environment those objects will fail to import.

    The REMAP_TABLESPACE option in datapump works well for this, especially when you have a hundred or so tablespaces.
    I remember when this place was cool.

  4. #4
    Join Date
    Oct 2007
    Posts
    31

    Need to Copy Schema to Prod

    Thanks for your input.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    dbms_metadata.get_ddl
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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