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: