5 Replies Latest reply: Jan 25, 2013 6:26 AM by Dean Gagne RSS

    DATA PUMP full import?

    user9106065
      I need help from you.

      Oracle 10.2.0.4g database, on Windows Server 2003

      I want to do DATA PUMP import (without indexes) to database instance name B from database instance name A.
      OS and Oracle version are the same in both servers.

      Import should overwrite all existing objects.

      Thanks!

      Edited by: user9106065 on Jan 23, 2013 12:54 AM
        • 1. Re: DATA PUMP full import?
          Niket Kumar
          please specify oracle version and error you are getting in import and what os you are using....
          • 2. Re: DATA PUMP full import?
            dataseven
            hi,

            you can use network link from new server B to old server A. you have to exclude system users and indexes like below .

            For example from 10g to 11g

            impdp username/password FULL=Y
            EXCLUDE=SCHEMA:"in ('DVSYS','DVF','DVOWNER','ACCTMGR','DMSYS','TSMSYS','WMSYS','EXFSYS','CTXSYS','XDB','OLAPSYS','ORDSYS','MDSYS','D
            IP','ORACLE_OCM','MDDATA','DBSNMP','ANONYMOUS','SYSMAN','ORDPLUGINS','SI_INFORMTN_SCHEMA','SYS','SYSTEM','OUTLN,MGMT_VIEW')",TABLESP
            ACE,STATISTICS,INDEX NETWORK_LINK=newserver_to_oldserver

            regards,

            Edited by: dataseven on 23.Oca.2013 01:06
            • 3. Re: DATA PUMP full import?
              757008
              impdp help=y

              impdp EXCLUDE=INDEX TABLE_EXISTS_ACTION=replace directory=<name> logfile=<name> dumpfile=<name>


              Regards,
              V
              • 4. Re: DATA PUMP full import?
                TSharma-Oracle
                In this case the key is

                TABLE_EXISTS_ACTION=replace means if Oracle finds table with the same name, it will replace with new loading table.
                EXCLUDE=INDEX means you are excluding all the indexes while importing.

                impdp user directory=directoryname logfile=logfilename dumpfile=dumpfilename EXCLUDE=INDEX TABLE_EXISTS_ACTION=REPLACE.

                This should work for you.
                • 5. Re: DATA PUMP full import?
                  Dean Gagne
                  I want to do DATA PUMP import (without indexes) to database instance name B from database
                  instance name A.
                  To exclude indexes, use the exclude like everyone has said.
                  Import should overwrite all existing objects.
                  Data Pump can't overwrite all existing objects. All it can do is overwrite tables. If you have types, procedures, functions, etc in your dump file, they will not get overwritten. There is a lot of confusion in here about that.

                  Dean