5 Replies Latest reply: Jan 16, 2013 3:44 PM by 980614 RSS

    support for exp and imp in 11g

    A-K
      Hi,

      Is exp and imp utility supported in 11g ?
      please provide me some oracle documentation link.

      Can a dump file of 10g which is created with 'exp' utility be imported in 11g using 'imp' utility.
      Or this has to be done only with 'expdp' and 'impdp' utility.


      Thanks.
        • 1. Re: support for exp and imp in 11g
          CKPT
          yes you can do , but you have so many features with datapump(compression, faster), then why should you use still taraditional?
          but still exp/imp are for compatibility. in 11g

          check http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm

          Edited by: CKPT on Aug 11, 2010 12:39 PM
          • 2. Re: support for exp and imp in 11g
            Nicolas.Gasparotto
            EXP/IMP is desupported in 11gR1 :
            http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm#SUTIL001
            But yes, you could still use it.

            Nicolas.
            • 3. Re: support for exp and imp in 11g
              Chinar
              Read below link
              http://download.oracle.com/docs/cd/E11882_01/server.112/e10701/original_export.htm#SUTIL3634
              • 4. Re: support for exp and imp in 11g
                Fahd.Mirza
                Yes that is possible.


                regards
                • 5. Re: support for exp and imp in 11g
                  980614
                  There are a number of reasons you may want to use the traditional IMP/EXP.

                  To use Data Pump you need the DBA to set you up.
                  The traditional tools are client/server oriented, so as long as you have a user connection to the DB you can do use EXP and IMP.
                  But, to use DataPump, you have to request access to a Server Dir (that means you need to ask both the DBA and the Sys admin to set you up).
                  If you are exporting from one server and importing into another, then you may need 4 guys to give you access, disk space, and what not.

                  Last and least, the backward compatibility. If, for example, you have scripts that use IMP/EXP to automatically move stuff between two DBs, you may not want to start rewriting them.

                  I really hope they don't de-support the good old traditional nice IMP/EXP.

                  Fabian.