Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Making a "copy" of a schema.

Re: Making a "copy" of a schema.

From: Andres Estrada <aestrada_at_swbell.net>
Date: Wed, 12 Mar 2003 00:08:33 GMT
Message-ID: <5Uuba.439$xD.144696543@newssvr30.news.prodigy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US