Transportable tablespace issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Transportable tablespace issues

Threaded View

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    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 09: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
  •  



Click Here to Expand Forum to Full Width