This content has been marked as final. Show 5 replies
santi wrote:How about using transportable database feature?
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?
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