Professional Web Applications Themes

Snapshot on a Snapshot - Oracle Server

In article <bdcc590d.0212101011.3acce77eposting.google.com >, [email]aennenamdocs.com[/email] says... > >Is this possible and if so are there any issue of risks that one >should be aware of in doing something like this. > >What we are trying to accomplish is to have a seperate table (fondly >called a delta table) with only the changes that have occured over a >period of time but still keeping the oringinal snap shot full and >intact for performance reasons. It certainly is in 9i, but unfortunately you didn't mention which version you're on. Can't remember if it was there in 8i, but I don't think so. ...

  1. #1

    Default Re: Snapshot on a Snapshot

    In article <bdcc590d.0212101011.3acce77eposting.google.com >, [email]aennenamdocs.com[/email]
    says...
    >
    >Is this possible and if so are there any issue of risks that one
    >should be aware of in doing something like this.
    >
    >What we are trying to accomplish is to have a seperate table (fondly
    >called a delta table) with only the changes that have occured over a
    >period of time but still keeping the oringinal snap shot full and
    >intact for performance reasons.
    It certainly is in 9i, but unfortunately you didn't mention which version you're
    on. Can't remember if it was there in 8i, but I don't think so.

    HTH. Additions and corrections welcome.

    Pete

    SELECT standard_disclaimer, witty_remark FROM company_requirements;

    Pete Sharman Guest

  2. #2

    Default Re: Snapshot on a Snapshot

    Some problems with nested materialized views:

    [url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0211191124.7c9dadde%40posting.goog le.com[/url]
    [url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0210251116.72e8bfaf%40posting.goog le.com[/url]

    Also, you might want to take a look at 9i CDC (change data capture)
    see if it makes life easier for you.


    - Jusung Yang


    You might want to take a look at CDC (change data capture)
    [email]aennenamdocs.com[/email] (Alan) wrote in message news:<bdcc590d.0212101011.3acce77eposting.google. com>...
    > Is this possible and if so are there any issue of risks that one
    > should be aware of in doing something like this.
    >
    > What we are trying to accomplish is to have a seperate table (fondly
    > called a delta table) with only the changes that have occured over a
    > period of time but still keeping the oringinal snap shot full and
    > intact for performance reasons.
    Jusung Yang Guest

Similar Threads

  1. Snapshot issue
    By emullet in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: December 18th, 11:36 PM
  2. Using LVM snapshot to backup database
    By Johan Louwers in forum Linux / Unix Administration
    Replies: 0
    Last Post: April 6th, 12:23 PM
  3. Snapshot of FLV
    By U. Tote in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 16th, 03:51 PM
  4. snapshot
    By Jaz in forum AIX
    Replies: 5
    Last Post: July 18th, 07:47 PM
  5. Snapshot of 3D scene?
    By Phoonzang webforumsuser@macromedia.com in forum Macromedia Director 3D
    Replies: 2
    Last Post: July 9th, 11:01 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139