Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    13

    Unanswered: difference between Remap_schema and Schemas parameter

    Hi all,

    I want to import a schema from the dump file.That dump file exists DILEEP schema information.I would like t import that information into the KUMAR schema.In this case what parameter do i need to use? Whether Remap-schema=DILEEP:KUMAR or schemas=KUMAR

    Thanks in advance
    Dileep

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As "source" and "target" schemas are different, I believe that REMAP_SCHEMA should be used here. If you used the original EXP and IMP utilities in previous Oracle database versions, then REMAP_SCHEMA does the same job as IMP's FROMUSER - TOUSER parameters used to do.

    REMAP_SCHEMA is capable of creating the target schema if it doesn't exist, but only if the user (you are importing data with) has required privileges. For example: EXP_FULL_DATABASE and IMP_FULL_DATABASE roles make such things possible. So, if user "dileep" has these privileges, you'd
    Code:
    expdp dileep/pwd directory=your_exp_dir file=dileep.dmp
    
    impdp dileep/pwd directory=your_exp_dir file=dileep.dmp remap_schema=dileep:kumar

Posting Permissions

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