Results 1 to 2 of 2

Thread: Exp/Imp issue

  1. #1
    Join Date
    Mar 2006

    Exclamation Unanswered: Exp/Imp issue

    hi all,

    I'm new to oracle.
    is it possible to do a full export and then import only one Schema?
    We're useing 8.1.6

    Thanx in advance,


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Yes, it is possible. On Scott's schema, the simplest example would be like this:

    EXP scott/tiger FILE=scott.dmp

    IMP scott/tiger FILE=scott.dmp

    As both EXP and IMP utility have numerous options, you might want to read more about them here (export) and here (import).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts