Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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?

Tim... said...


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

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

Tim... said...


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.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
(max 400 chars - plain text)