5 Replies Latest reply: Nov 20, 2012 4:40 AM by Girish Sharma RSS

    Issue during importing metadata for transportable tablespace

    santi
      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....
          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
            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
              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
                12cdb
                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
                  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