Originally posted by Sweetie
hi

snapshots are materialized views, they are synonyms
You are so sweet...

Materialized view
1. They consume storage space.
2. They must be refreshed when the data in their master tables changes.
3. They improve the performance of SQL execution when they are used for query rewrites.


A synonym is an alias for any table, view, materialized view, sequence, procedure, function, or package. Because a synonym is simply an alias, it requires no storage other than its definition in the data dictionary.

I won't call them synonym...

There should not be any problem in upgradation as log you do not use export import as a method for upgradation...

I had some problem using export/import, while importing the snapshots were converted to tables... Talked to the peeps at Oracle and they just made me run looking for those traces and finally no solution...

So finally had to find other ways to do upgradation.

HTH