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

Thread: importing a schema from full db export dump

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Gurus/Members

    I have a full db export dump file 'fullexp.dmp', and want to import only the scott schema objects from this dump into the database from the full dump file. Can someone please give me the syntax to do this? Thanks a lot!!
    roukie-dba

  2. #2
    Join Date
    Oct 2001
    Posts
    83

    Arrow

    HELLO,

    1. Create the user SCOTT and grant him the right privileges.
    2. Use the option FROMUSER when invoking IMP command :
    IMP login/passwd FROMUSER=SCOTT others_options...

    Hope this helps...

    Regards

    NOOR

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