-
Transportable tablespace issues
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,
Last edited by castlerock; 12-02-2009 at 10:09 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|