how to move one schema db to another schema db using toad 9.5?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ramanan ram
    New Member
    • Feb 2012
    • 26

    how to move one schema db to another schema db using toad 9.5?

    hi,
    i trying to move one schema tables with constraints ,functions and procedures to another db schema.

    example:
    from :db name: poms,
    schema :pipeline
    TO:
    db name: prmy
    schema: tapestry

    please give solution...
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You need to use the utilities EXP/EXPDP and IMP/IMPDP depending on the versions of the oracle that you are using.

    Comment

    Working...