Comments on Oracle DBA and RAC DBA Expert: Transportable tablespace export and Import

Use the below syntax:- impdp username/pwd DIRECTOR...

2011-01-20T10:15:35.210-08:00

Use the below syntax:-
impdp username/pwd DIRECTORY=directory_name DUMPFILE=test_dmp.dmp logfile=test_log.log
SCHEMAS=ABC REMAP_SCHEMA=ABC:XYZ REMAP_TABLESPACE=ABC:XYZ

But please note that user default tablespace on target should be XYZ.

"Satishbabu Gunukula said... Either you ...

2010-03-31T07:39:08.295-07:00

"Satishbabu Gunukula said...

Either you can rename the tablespace to be transported or destination tablespace before the transport operation."

Using the REMAP? If we just want to use IMPDP TTS, and rename it from TBSX to TBSY...syntax?

Either you can rename the tablespace to be transpo...

2010-01-15T11:25:33.256-08:00

Either you can rename the tablespace to be transported or destination tablespace before the transport operation.

Great job for this article. I am in the middle to...

2010-01-15T06:48:34.694-08:00

Great job for this article. I am in the middle to moving data between servers (production and cloned databases). I will like to use this option, but how can I over this condition?

"You cannot transport a tablespace to a target database which already exists".

great this will help in my next serve migration. T...

2010-01-04T15:04:29.787-08:00

great this will help in my next serve migration.
Thanks for this nice blog.

Oracle's transportable tablespace feature allo...

2009-12-21T06:37:18.747-08:00

Oracle's transportable tablespace feature allows users to quickly move a user tablespace across Oracle databases. It is the most efficient way to move bulk data between databases. Moving data using transportable tablespaces can be much faster than performing either an export/import or unload/load of the same data. This is because transporting a tablespace only requires the copying of datafiles and integrating the tablespace structural information.nbsp; You can also use transportable tablespaces to move both table and index data, thereby avoiding the index rebuilds you would have to perform when importing or loading table data.

16gb micro sd karte