This content has been marked as final. Show 3 replies
Anyone can help? thanks!
TTS will includes all type of objects in that transportable tablespaces set. It will include mview logs as well.
For Production Database where all the mview logs and master tables at, we can use transportable tablespace. I supposed transportable tablespace should be ablt to transport mview logs as well? Can advise what are the type of objects tts doesn't migrate?
are you sure about above statement ? Is mviews not transported when you used TTS ?
For mview site, seems that transportable tablespace doesn't migrate mviews over. As such the only option is through datapump exp/imp.
In TTS all the objects within the data tablespace are migrated.
See, if this is useful..
Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable [ID 1454872.1] To Bottom