DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Snapshot

  1. #1
    Join Date
    Feb 2003
    Posts
    4

    Snapshot

    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

  2. #2
    Join Date
    Oct 2000
    Posts
    139
    hi

    snapshots are materialized views, they are synonyms

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Oct 2000
    Posts
    139
    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

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Pardon me...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Or...

    synonymous
    Last edited by grjohnson; 02-24-2003 at 07:15 PM.
    OCP 8i, 9i DBA
    Brisbane Australia

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Snapshot

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width