5 Replies Latest reply: Dec 16, 2012 3:41 AM by Osama_Mustafa RSS

    clone database using impdp

    951027
      Hello all,

      I have a full database dump file. which was taken from production server. i want to create a test db in my laptop

      Is ther any step by step guide in order to do this impdp from the begining i mean from creating initialiazation parameter,
      directory structure or creation of tablespaces.


      Thanks
        • 1. Re: clone database using impdp
          Osama_Mustafa
          Install oracle on clone sever , create database using dbca ...



          also Refer to this
          http://ahsan-javed.blogspot.com/2009/12/expdpimpdp-example-in-oracle-for.html
          http://www.club-oracle.com/forums/duplicating-database-using-expdp-impdp-t5921/

          Edited by: Osama_mustafa on Dec 16, 2012 10:21 AM
          • 2. Re: clone database using impdp
            951027
            thanks but it says

            Here are the steps to do the * schema copy from one database to another*. You need to be admin user for performing some tasks.

            also what about the tablespaces do i need to create them, there is a clause mentioned

            remap_tablespace=mytablespace:yourtablespace

            how to use the above for multiple tablespaces

            and if the tablespaces are not there will it create new?

            thanks
            • 3. Re: clone database using impdp
              Osama_Mustafa
              948024 wrote:
              thanks but it says

              Here are the steps to do the * schema copy from one database to another*. You need to be admin user for performing some tasks.

              also what about the tablespaces do i need to create them, there is a clause mentioned

              remap_tablespace=mytablespace:yourtablespace

              how to use the above for multiple tablespaces

              and if the tablespaces are not there will it create new?

              thanks
              No it won't create tablespace , You use remap option for your tablespace like the following :
              REMAP_TABLESPACE=(OLD:NEW,OLD:NEW,OLD:NEW,OLD:NEW)
              if you don't want to use remap then you should create your tablespace .
              • 4. Re: clone database using impdp
                951027
                Thanks alot guys

                just one more thing what about user accounts im gettin invalid password errors for each user


                what can be done to get the same passwords of them?
                • 5. Re: clone database using impdp
                  Osama_Mustafa
                  948024 wrote:
                  Thanks alot guys

                  just one more thing what about user accounts im gettin invalid password errors for each user


                  what can be done to get the same passwords of them?
                  Generate Spool File like the following on Source :

                  if create user ddl exported, then imp should create the targeted user otherwise use manual way :
                  Spool User.sql 
                  Select ' Create ' || ' '   ||username || ' '   || 'identified by' || ' '|| password from dba_users ;
                  Spool off ;