This discussion is archived
5 Replies Latest reply: Nov 20, 2012 2:40 AM by Girish Sharma RSS

Issue during importing metadata for transportable tablespace

santi Newbie
Currently Being Moderated
Hi,

We are migrating one of our databases from linux to AIX (testing phase). We're using transportable tablespace for the same. All steps are done and we're stuck during importing the metadata. While importing metadata we require to mention fully qualified datafile name which has to be plugged. The number of datafiles is 309 and the name of the all the datafiles has to be in one line. Now if we try to write it in one line using vi editor, the editor gives error 'ex: 0602-140'.

Is there a way by which we can overcome this situation?

Regards,
  • 1. Re: Issue during importing metadata for transportable tablespace
    Aman.... Oracle ACE
    Currently Being Moderated
    santi wrote:
    Hi,

    We are migrating one of our databases from linux to AIX (testing phase). We're using transportable tablespace for the same. All steps are done and we're stuck during importing the metadata. While importing metadata we require to mention fully qualified datafile name which has to be plugged. The number of datafiles is 309 and the name of the all the datafiles has to be in one line. Now if we try to write it in one line using vi editor, the editor gives error 'ex: 0602-140'.

    Is there a way by which we can overcome this situation?
    How about using transportable database feature?
    http://docs.oracle.com/cd/E11882_01/server.112/e10803/schedule_outage.htm#BABDGDGE

    Aman....
  • 2. Re: Issue during importing metadata for transportable tablespace
    Niket Kumar Pro
    Currently Being Moderated
    try parfile option make a vi editor file which contains datafile option and 309 lines of datafile.this way you nned not to put everything in same line.
  • 3. Re: Issue during importing metadata for transportable tablespace
    santi Newbie
    Currently Being Moderated
    Transportable database is feasible only when both the platforms have same endian. But in my case, linux and AIX have different endians, so I'll have to use transportable tablespace.

    Regards,
  • 4. Re: Issue during importing metadata for transportable tablespace
    user296828 Expert
    Currently Being Moderated
    As mentioned as well, you can use param.par file.

    impdp PARFILE=param.par


    $cat param.par
    transport_tablespace=y
    datafiles=/<path>/file01.dbf,
    /<path>/file02.dbf
  • 5. Re: Issue during importing metadata for transportable tablespace
    Girish Sharma Guru
    Currently Being Moderated
    See this example at below link :
    Import the Metadata
    The final step on the target site is to import the tablespace metada. For this pupose you may simply create a data pump parameter file using your favorite text editor.
    
    himalaya@oracle $ vi import.par
    “import.par” [New file]
    
    directory=ADMIN_DIR
    dumpfile=staging_asn.dmp
    logfile=ADMIN_DIR:asn.log
    transport_datafiles=’/export/home/oracle/hsensoy/datafile/staging1.dbf’,'/export
    /home/oracle/hsensoy/datafile/staging2.dbf’,'/export/home/oracle/hsensoy/datafil
    e/staging3.dbf’
    keep_master=y
    ~
    ~
    ~
    “import.par” [New file] 5 lines, 262 characters
    
    Then using this file you can perform the import
    
    himalaya@oracle $ impdp userid=ddsbase/****** parfile=import.par
    http://husnusensoy.wordpress.com/2008/07/12/migrating-data-using-transportable-tablespacetts/

    Regards
    Girish Sharma

Legend

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