4 Replies Latest reply: Jan 22, 2013 12:44 PM by Dean Gagne-Oracle RSS

    import mode FULL conflicts with export mode TRANSPORTABLE

    Dan Abugov
      Hi,

      We are trying to import transportable tablespaces and are getting an error "import mode FULL conflicts with export mode TRANSPORTABLE. This is the second time we've seen it, the common thread seems to be that it only shows up with the remap_schema qualifier (the example below is with ASM, but we have seen it also without ASM). Does anyone have any suggestions as to how this can be resolved?

      Thanks,
      Dan

      impdp SYSTEM/xxxxx@DEVSUP DIRECTORY=CSF_DIR DUMPFILE=csf_au_q412_b1.dmp logfile=dev_imp.log TRANSPORT_DATAFILES='+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1130.804322725','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.631.804322681','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.798.804322635','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.968.804322581','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1261.804322791','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1727.804322951','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.309.804322865','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.684.804323047','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.752.804323141','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.843.804323247' remap_schema=CSF_AU_Q412_B1:CSF

      ORA-39002: invalid operation
      ORA-39061: import mode FULL conflicts with export mode TRANSPORTABLE
        • 1. Re: import mode FULL conflicts with export mode TRANSPORTABLE
          Dean Gagne-Oracle
          What version is this on? This doesn't make much sense because you don't have full=y. Are you sure that the export was done using transportable tablespace? if the export was full, then the import can't be transportable.

          Can you list the version you are using and maybe the export command.

          Thanks

          Dean
          • 2. Re: import mode FULL conflicts with export mode TRANSPORTABLE
            Dan Abugov
            Just in case anyone else runs into this, the problem was resolved by reordering the file names numerically:

            impdp SYSTEM/devsupmgr@DEVSUP DUMPFILE=csf_au_q412_b1.dmp DIRECTORY=CSF_DIR TRANSPORT_DATAFILES= '+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.968.804322581','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.798.804322635','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.631.804322681','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1130.804322725','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1261.804322791','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.309.804322865','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.1727.804322951','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.684.804323047','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.752.804323141','+DATA/PMDEVSUP/DATAFILE/CSF_AU_Q412_B1.843.804323247' remap_schema=CSF_AU_Q412_B1:CSF

            Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK Processing object type TRANSPORTABLE_EXPORT/TABLE Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
            Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
            Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
            Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 15:18:28
            • 3. Re: import mode FULL conflicts with export mode TRANSPORTABLE
              user5518614
              We are trying to import transportable tablespaces and are getting an error "import mode FULL conflicts with export mode TRANSPORTABLE

              impdp SYSTEM/****@ESUST DIRECTORY=CSF_DIR DUMPFILE=csf_na_q212_b1.dmp
              TRANSPORT_DATAFILES='+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1907.805396709','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1908.805396709','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1909.805396653','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1910.805396647','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1911.805396591','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1912.805396591','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1913.805396535','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1914.805396535','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1915.805396479','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1916.805396479','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1917.805396425','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1918.805396425','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1919.805396369','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1920.805396365','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1921.805396321','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1932.805396319','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1933.805396263','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1934.805396261','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1935.805396205','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1936.805396201','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1937.805396137,+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1938.805396137,+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1939.805396081','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1954.805396079','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1958.805396013,+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1959.805396013,+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1960.805395937,+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1961.805395923','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1962.805395867','+DATA/PMESUST/DATAFILE/CSF_NA_Q212_B1.1963.805395867' remap_schema=CSF_NA_Q212_B1:CSF


              ORA-39002: invalid operation
              ORA-39061: import mode FULL conflicts with export mode TRANSPORTABLE
              • 4. Re: import mode FULL conflicts with export mode TRANSPORTABLE
                Dean Gagne-Oracle
                To help, we really need to know the version of the database that you did the export and then the import on. There have been changes in this area and without that information, it will be very hard to determine what is happening. It still may not be possible with the information, but it could help alot.

                Dean