This discussion is archived
4 Replies Latest reply: Jan 22, 2013 10:44 AM by Dean Gagne RSS

import mode FULL conflicts with export mode TRANSPORTABLE

Dan Abugov Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points