Transportable tablespace issues

[castlerock]

I am doing TTS from TRU64 (Bid endian format)to HPUX (little endian format).... having issues during impdp

steps at source:
---------------

begin
sys.dbms_tts.transport_set_check('TESTTBLSPC',TRUE);
end;
/
....repeated for two tablespaces

alter tablespace TESTTBLSPC read only; - did for both tablespaces

expdp userid=userid/pwd DIRECTORY=DATA_PUMP_DIR DUMPFILE=TTS.dmp LOGFILE=TTS.log TRANSPORT_TABLESPACES=TESTTBLSPC,TESTTBLSPCS TRANSPORT_FULL_CHECK=y


steps at target:
--------------
ftped the dumpfile and the two datafiles to the respective location /dbfiles/oradata/DBNAME and the target database is up and running

The export contains two tablespaces with each one datafile... i am trying to import one tablespace

impdp userid=ramesh/ramesh DIRECTORY=DATA_PUMP_DIR DUMPFILE=TTS.dmp LOGFILE=TTSimp.log TRANSPORT_DATAFILES=’/dbfiles/oradata/DBNAME/testtblspc.dbf’ KEEP_MASTER=y

error:
ORA-39123: Data Pump transportable tablespace job aborted
ORA-01565: error in identifying file '/dbfiles/oradata/DBNAME/testtblspc.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

Job "USERID"."SYS_IMPORT_TRANSPORTABLE_02" stopped due to fatal error at 16:43:24

1.DOES THE MOUNT POINT NAME ON THE TARGET HAS TO BE THE SAME AS SOURCE ?
2. INSTEAD OF DOING ONE DATAFILE AT A TIME FOR EACH TABLESPACE.. CAN I DO MULITPLE TABLESPACES USING TRANSPORTABLE_TABLESPACES = TABLESPACENAME.dbf, TABLESPACENAME2.dbf?


Many Thanks,

[Thomas7]

I think for transfer of tablespace's from one endian format to another endian format you must use RMAN Convert command either on the source or target systems. Query v$transportable_platform to get the target platform name.

Bring the tablespace to read only mode

on the source platform
Example:
rman>convert tablespace 'SAMPLE'
to platform='AIX Based(64 bit)'
db_file_name_convert='/u01/oradata/index01.dbf','/usr/tmp';

copy the file to target and import the metadata and bring the tablespace online.