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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB copying : Attack of the Clones!

Re: DB copying : Attack of the Clones!

From: Henry Poras <hporas_at_attbi.com>
Date: Fri, 19 Jul 2002 05:53:20 -0800
Message-ID: <F001.0049C849.20020719055320@fatcity.com>


Dale,
Is referential integrity (foreign keys) a requirement to get your subsets?

Henry

> Hi Kirti
>
> Do you absolutely need full size copies? If small referentially correct
> subsets were suitable you could use our DataBee software to "re-create and
> re-load" the test databases as necessary.
>
> In other words, you would not need to back up and restore full size
> databases. You simply press the button and regenerate the subsets when
> required. Depending on the size of the subset, the refresh would not take
> more than an hour or two. The load process is quite straight forward -
many
> of our customers just create the initial subset databases and then off
load
> the "truncate and reload" work to the developers and testers themselves.
The
> DBA's are removed from the loop and because the databases are small the
> create process is very quick - the developers and testers can refresh
their
> databases whenever they want.
>
> Actually, DataBee would clone the full size databases just fine - its just
> not really designed for that purpose in mind.
>
> DataBee: http://www.DataBee.com
>
> In any event, you should have a look at our freeware DBATool. It contains
> (among other things) a rule based schema adjuster that should take care of
> your requirements to modify the DDL in the test schemas
> http://www.DataBee.com
>
> Thanks
> Dale Edgar
> Net 2000 Ltd.
> Dale_at_DataBee.com
>
>
> > I was 'volunteered' to participate in a task force charged with finding
> > quick solutions (in less than 2 weeks) to support following Dgmt
decision:
> > Clone 14 production databases in their entirety for ongoing code
testing,
> > recreating production problems etc.
> >
> > BTW, if we decided on any 3rd party tools, then Dgmt wants it installed
> > within the next 4-5 weeks. Any Vendor types lurking on the list? This is
> > your chance :)
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Dale_at_DataBee.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: hporas_at_attbi.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 19 2002 - 08:53:20 CDT

Original text of this message

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