Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transportable Tablespace vs Datapump Exp/IMP

ChewyMar 28 2012 — edited Sep 6 2016
Hi Guys,
10.2.0.5

Will need your advise here before i start some test on it.

I have 2 databases.
One of them is the production database (master site) and the other a mview site (read only mviews).
I will need to migrate both of them from HP-UX to Solaris (different endian).

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?

For mview site, seems that transportable tablespace doesn't migrate mviews over. As such the only option is through datapump exp/imp.

Any suugestion for this scenario?

thanks!
This post has been answered by 23ai on Nov 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2012
Added on Mar 28 2012
3 comments
810 views