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!

Importing Materialized Views issue

DsteakFeb 12 2009 — edited Feb 17 2009
We have a situation where we need to move our data from one schema to another on different db instances. When we export/import the materialized views, they are stored with a MASTER_OWNER of the exporting schema, which doesn't exist in the importing database instance, hence, when we then refresh them, they fail. These are MV"s set at full refresh, not fast refresh. Basically we just want the MV's from the other schema without having to drop and recreate them since that takes a while. We need them to behave just like tables during the import. They already contain the data we need.

Any thoughts or solutions out there?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2009
Added on Feb 12 2009
2 comments
1,040 views