how to find/set the parameter in DBMS_DATAPUMP as REMAP_SCHEMA in impdp

Posted on 2009-04-15
Last Modified: 2013-12-18
in impdp, I can import a table to different schema as REMAP_SCHEMA=A:B from schema A to B, but is there any equalvent statement in DBMS_DATAPUMP, which I will do the same as impdp?
Question by:jl66

    Author Comment

    I just couldn't find this one.
    LVL 22

    Accepted Solution

    you could use 
    name parameter should be REMAP_SCHEMA.
    Any schema object in the job that matches the object_type parameter and was 
    located in the old_value schema will be moved to the value schema.
    Privileged users can perform unrestricted schema remaps.
    Nonprivileged users can perform schema remaps only if their schema is the target schema of the remap.
    For example, SCOTT can remap his BLAKE's objects to SCOTT, but SCOTT cannot remap SCOTT's objects to BLAKE.


    Ivo Stoykov

       handle      IN NUMBER,
       name        IN VARCHAR2,
       old_value   IN VARCHAR2,
       value       IN VARCHAR2,
       object_type IN VARCHAR2 DEFAULT NULL);

    Open in new window

    LVL 15

    Assisted Solution

    LVL 22

    Expert Comment

    by:Ivo Stoykov
    Perhaps I've missed something... isn't it what are you looking for?

    "The METADATA_REMAP procedure is only supported for Import and SQL_FILE
    operations. It enables you to apply commonly desired, predefined remappings to
    the definition of objects as part of the transfer. If you need remaps that are not
    supported within this procedure, you should do a preliminary SQL_FILE
    operation to produce a SQL script corresponding to the dump file set. By editing
    the DDL directly and then executing it, you can produce any remappings that you

    LVL 15

    Expert Comment

    ivostoykov: Sorry if I caused confusion.
    My comment was asking jl66 if the METADATA_REMAP procedure would suit.
    I must have been typing while you were posting.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now