Importing thru Impdp

Posted on 2009-04-23
Last Modified: 2013-12-18
I need to refresh my test db and want to use dump file. All the tables are in one schema. Here is my par file that I am using to import. Is there any other parameter that I need to refrence inorder to see a clean Import?
Question by:bonna
    LVL 40

    Accepted Solution

    If you want to guarantee the import is "clean" make sure the schema is empty before import, otherwise your options look fine. WHen I refresh a schema, I usually drop user cascade, then recreate it, prior to import.

    LVL 3

    Assisted Solution

    There are a couple of others you could try:

    These allow you to connect to the production database directly and skip the export step.  Not necessary if you're already doing the export step.

    Set it to TRUNCATE to truncate rows in existing tables
    Set it to REPLACE to drop and recreate existing tables
    Of those two, TRUNCATE is probably the more efficient.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    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…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now