What version of ORACLE are you using? I have heard people complaining
about exp/imp materialized views with different versions of ORACLE.
With 9i release 2 MV names do show up in USER_MVIEWS after import.
However the entries in user_registered_snapshots are gone. If you
define the MVs to refresh on a regular basis, either fast or complete,
you will find they are no longer working since all the entries in the
user_jobs are gone after import. I would say if the MVs are eazy to
create, just recreate them after import. If the MVs contains large
amount of data and take a while to build, try using the "on Prebuilt
table" clauze. I have not done exhaustive test on this though. Too
many scenarios with MVs exp/imp, partitioning for example.
"Georg Scholz" <georg.scholz_at_vienna.at> wrote in message news:<W%Wm9.128286$142.1677538_at_news.chello.at>...
> Dear all,
>
> I want to copy an Oracle Database from one computer to another.
>
> So I did a full export, and then an import (exp / imp).
>
> Now in the new database, all those snapshots which refresh on commit, are
> shown as TABLES, not as SNAPSHOTS.
>
> Furthermore, the view declaration which is behind the snapshots is lost! So
> when changing the source data tables, the snapshots are no longer refreshed.
>
> Any help is highly appreciated!
>
> Many thanks
>
> Georg Scholz
Received on Thu Oct 03 2002 - 15:00:30 CDT
