This content has been marked as final. Show 3 replies
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.