|Transportable Tablespaces - Copy tablespaces to new instances in the time it takes to copy the datafiles.|
Paul Muller said...Nice example.
I used this as a starting point when I used transportable tablespaces to quickly change ownership of a few large tables to a different schema in the same database.
CTAS was out because of the space requirements and the long time it would take to copy data and build indexes.
Anyway, I found that you can use fromuser and touser when importing the transportable tablespace.
Amol said...This article is very nice.It helped me a lot .
Jianing said...export did not work
Nice one said...It is really a helping one ....
efachim said...Nice explanation, but you did not say whether the datafile in the w2k2 instance had to have been created prior to the import. Or does listing it as an import parameter create it?
The articles says you must copy the datafile manually. The import only imports the metadata for the datafile. It's up to you to manually transfer the datafile. That's the point of transportable tablespaces. :)
Rajavelu said...Impdp is not working showing error msg
SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": userid=system/******** directory=temp_dir dumpfile=test_data.dmp logfile=test_data_imp.log transport_datafiles=/u01/app/oracle/product/10.2.0/oradata/orcl/test_data01.dbf
Raja Velu said...Impdb is not working showing error msg
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-19722: datafile /u01/app/oracle/product/10.2.0/oradata/orcl/test_data01.dbf is an incorrect version
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 21:09:53
The error message says it all. Read the action associated with the error in the manual. If you have any further questions, please ask them in the forum, not here.
Vimal said...Thanks so much..Works very well.