2 Replies Latest reply: Jan 23, 2013 6:49 PM by Simon_DBA RSS

    IMP with multiple dump files and multiple remap_tablespace - Will it work?

    985512
      Hi.

      I have 3 dump files: A.dmp, B.dmp, C.dmp
      Can I use multiple REMAP_TABLESPACE entries in a par file to remap the table spaces for the above dump file?

      Parfile would look something like this:


      DIRECTORY=dpump
      DUMPFILE=A.dmp,B.dmp,C.dmp
      JOB_NAME=import_3_schemas
      REMAP_TABLESPACE=A1:D1
      REMAP_TABLESPACE=B1:E1
      REMAP_TABLESPACE=C1:F1

      The first remap entry is only relevant to A.dmp file
      The second remap entry is only relevant to B.dmp file
      etc.

      Thank You!