Importing Materialized Views issue
DsteakFeb 12 2009 — edited Feb 17 2009We 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.