2 Replies Latest reply: Feb 11, 2013 11:49 AM by RK334 RSS

    import full database question

    926398
      We running oracle rdbms 11.2.0.3 on aix 6.2 and I am going to create a copy of a production database by using expdp and impdp. My quesition is that the target database for the impdp already has all of the data from the last time we refreshed from prod.
      Can I do a fulll database import over the top of what is already there or do I have to start with a blank general purpose database first?
      Thanks.
        • 1. Re: import full database question
          Srini Chavali-Oracle
          You can certainly import - see TABLE_EXISTS_ACTION option in impdp - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#sthref299

          Is there a reason you are using this process for refreshing a database ? Other options (such as RMAN DUPLICATE) also exist to duplicate databases.

          HTH
          Srini
          • 2. Re: import full database question
            RK334
            >
            Can I do a fulll database import over the top of what is already there or do I have to start with a blank general purpose database first?
            You can use APPEND which would just append the data.

            Also, you can clear the objects on the target database and do a fresh import.