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:
REMAP_SCHEMA=hr:hr2
REMAP_TABLESPACE=hrdata:hrdata2

About these ads

3 Comments »

  1. And the link is … ?:)

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

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

    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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 300 other followers

%d bloggers like this: