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?
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.
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.
As mentioned as well, you can use param.par file.1 person found this helpful
See this example at below link :1 person found this helpful
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