10g and transportable tablespace on the same platform

Transporting tablespaces between platforms worked.

Now I'm trying to transport on the same platform (Windows)

expdp system_at_SRC_INST dumpfile=data.dmp directory=dumpdir transport_tablespaces=appdata

I get the dump file & the log file in the dumpdir directory

Then I do 2 separate things:

#1 RMAN

RMAN> connect target sys_at_SRC_INSTANCE
RMAN> convert tablespace appdata to platform 'Microsoft Windows IA (32- bit)' format 'c://temp/converted_%U';
RMAN> exit

--tablespace sits on a single datafile, I rename it for simplicity cp c://temp/converted_* c://temp/data.dbf

#2, alternatively

cp ${SRC_ORAHOME}/oradata/${SRC_INST}/data.dbf c://temp/data_cold_backup.dbf

Method 1 (trying to import with the RMAN-generated file:

impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data.dbf

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/ ********@DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-19722: datafile c://temp/data.dbf is an incorrect version

Method 2 (trying to import straight with the cold-copied file bypassing the conversion):

impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data_cold_backup.dbf

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/ ********@DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data_cold_backup.dbf Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-19721: Cannot find datafile with absolute file number 6 in tablespace APPDATA

Method 3 (take the cold-backed file and convert it on target)

#1 RMAN

RMAN> connect target sys_at_DEST_INSTANCE
RMAN> convert datafile 'c://temp/data_cold_backup.dbf' db_file_name_convert 'c://windows/temp', 'c://temp'; RMAN> exit

impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data_long_converted_name.dbf

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/ ********@DEST_INST dumpfile=data.dmp directory=dumpdir transport_datafiles=c://temp/data_long_converted_name.dbf Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-19721: Cannot find datafile with absolute file number 6 in tablespace APPDATA

So either way, the dump file is accepted, while the datafile isn't. But cross-platform, converted files get in ok.

Any ideas? Received on Thu Sep 13 2007 - 20:08:01 CDT