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
Printable View
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
hi
snapshots are materialized views, they are synonyms
You are so sweet...Quote:
Originally posted by Sweetie
hi
snapshots are materialized views, they are synonyms
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
When I said synonyms I meant it literally (as meaning from an english dictionary), snapshots are MVs and MVs are snapshots. I am not talking synonyms in Oracle
:D Pardon me...
Or...
synonymous :D
You might want to check if you should go via 8.1 - I'm sure I've seen that recommendation but can't remember where.Quote:
Originally posted by asheks
I am upgrading from 7.3.4 directly to 9.2
(grjohnson - I can't find the CREATE SYNONYMOUS command anywhere :) !)