Thinking Out Loud

August 27, 2013

RMAN Transportable Tablespace

Filed under: 11g,RMAN — mdinh @ 3:25 am

How many of you perform RMAN transportable tablespace on a regular basis and can do this from the top of your head?
What makes this post different from any other RMAN transportable tablespace post? I show you how to create objects not exported from transportable tablespace.
Did you know that transportable tablespace export does not include procedures, sequences, synonyms, etc …?
Check the document which I handily provided the link to or try searching for it.

The demo I did was to perform RMAN transportable export, eliminating the need to put production tablespace in READ ONLY.
HR was exported and imported to the same database using:



  1. And the link is … ?:)

    Comment by Greg — August 27, 2013 @ 8:02 am | Reply

  2. Thanks Michael , You are my Hero :).

    Comment by Greg — August 27, 2013 @ 3:03 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at

%d bloggers like this: