Why not use the SNAPSHOT structure that Oracle provides you ? The SNAPSHOT
is a great option gives us
Andres
"Mike" <michaelloll_at_hotmail.com> wrote in message
news:cba741c1.0303111028.1a869fcc_at_posting.google.com...
> Part of a project I am working on is making available a static
> snapshot of the database at a given time inteval - for example, the
> past four (4) weeks of data.
>
> Due to the processing involved, we simply can't query the data and
> specify a date range. One of our developers had the idea of creating
> a new schema (I'm not even sure if that is the correct term) for each
> copy, with a consistent naming convention. Then the appropriate users
> could connect through our front end to whichever "copy" they wanted.
>
> So, something like:
>
> 1) Stored Procedure runs at 2:30AM on a Sunday to create a schema
> called XYZ0312003 for the copy ending on date 03/15/2003.
>
> 2) We put logic into our front end that allows users to connect to
> whichever copy.
>
> Does this sound like a feasible situation? Barring size constraints
> (which are still unknown at this point), does this sound ok? The old
> "copies" wuld only allow READ access, not data updating or inserting.
>
> Thanks in advance.
>
> --
> Mike Loll
Received on Tue Mar 11 2003 - 18:08:33 CST
