I am upgrading from 7.3.4 directly to 9.2! I seem not to find any information relating to snapshots which are now called materialized views. Will Oracle handle to upgrade internally (snapshots - materialized views)? Any advice is welcome
snapshots are materialized views, they are synonyms
You are so sweet...
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.
Amar "There is a difference between knowing the path and walking the path."