tag:blogger.com,1999:blog-6850817271941197798.post6257210745419494597..comments2024-03-28T02:54:53.067-07:00Comments on Oracle DBA and RAC DBA Expert: Transportable tablespace export and ImportSatishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6850817271941197798.post-55272502861378960122018-07-07T03:23:15.205-07:002018-07-07T03:23:15.205-07:00loved the post. thanks.
72nd Happy Independence Da...loved the post. thanks.<br /><a href="http://independencedayindia2018.com/72nd-happy-independence-day-india-greetings-2018/" rel="nofollow">72nd Happy Independence Day India Greetings 2018</a>Anonymoushttps://www.blogger.com/profile/14775310290966491030noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-76504249177292134082011-01-20T10:15:35.210-08:002011-01-20T10:15:35.210-08:00Use the below syntax:-
impdp username/pwd DIRECTOR...Use the below syntax:-<br />impdp username/pwd DIRECTORY=directory_name DUMPFILE=test_dmp.dmp logfile=test_log.log<br />SCHEMAS=ABC REMAP_SCHEMA=ABC:XYZ REMAP_TABLESPACE=ABC:XYZ<br /><br />But please note that user default tablespace on target should be XYZ.Satishbabu Gunukulahttps://www.blogger.com/profile/02630966486825083489noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-38109472237584557802010-03-31T07:39:08.295-07:002010-03-31T07:39:08.295-07:00"Satishbabu Gunukula said...
Either you ..."Satishbabu Gunukula said...<br /><br /> Either you can rename the tablespace to be transported or destination tablespace before the transport operation."<br /><br />Using the REMAP? If we just want to use IMPDP TTS, and rename it from TBSX to TBSY...syntax?Unknownhttps://www.blogger.com/profile/16769928948085211225noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-60348355815233855722010-01-15T11:25:33.256-08:002010-01-15T11:25:33.256-08:00Either you can rename the tablespace to be transpo...Either you can rename the tablespace to be transported or destination tablespace before the transport operation.Satishbabu Gunukulahttps://www.blogger.com/profile/02630966486825083489noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-16325827533544935462010-01-15T06:48:34.694-08:002010-01-15T06:48:34.694-08:00Great job for this article. I am in the middle to...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?<br /><br />"You cannot transport a tablespace to a target database which already exists".Anonymoushttps://www.blogger.com/profile/09678044021914884092noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-36019154539811954582010-01-04T15:04:29.787-08:002010-01-04T15:04:29.787-08:00great this will help in my next serve migration.
T...great this will help in my next serve migration.<br />Thanks for this nice blog.Nitinhttps://www.blogger.com/profile/06713865256950228019noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-75559280386879533772009-12-21T06:37:18.747-08:002009-12-21T06:37:18.747-08:00Oracle's transportable tablespace feature allo...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. <br /><br /><a href="http://www.zoombits.de/speicherkarten/micro-sd-transflash/memory2go-16gb-micro-sdhc-speicherkarte-(klasse-2)/12316" rel="nofollow">16gb micro sd karte</a>Sara Reidhttps://www.blogger.com/profile/18373862159812719999noreply@blogger.com