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...
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
Amar "There is a difference between knowing the path and walking the path."
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
Originally posted by asheks I am upgrading from 7.3.4 directly to 9.2
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.
(grjohnson - I can't find the CREATE SYNONYMOUS command anywhere !)
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote
Pardon me...
!)
Bookmarks