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: Data Subset Tool?

Re: Data Subset Tool?

From: Jared Still <jkstill_at_cybcon.com>
Date: Sat, 19 Jan 2002 10:10:24 -0800
Message-ID: <F001.003F4E52.20020119092028@fatcity.com>

I've seen some pretty ugly schemas in Oracle, from third party apps in particular.

It would be most interesting if an automated tool could subset these.

Jared

On Friday 18 January 2002 23:20, Dale Edgar wrote:
> Hi Jared
>
> Disclaimer: I work for Net 2000 Ltd. the authors of DataBee - a database
> subsetting tool.
>
> > Disk is cheaper. :)
>
> It only seems so because manually creating subsets is such a nightmare -
> but if you have large databases it just isn't practical to give every
> developer, tester and trainer a full size copy of production. So what do
> you do? Well if your like most DBA's you create far fewer copies of the big
> database than is really needed and everybody has to share it. Then the
> trouble starts: the developers the collide with one another, the testers
> trash each others data and everybody squabbles because they have to wait
> for a time slot. Truth be known - developers, testers and trainers don't
> like to work on full size copys (it slows them down) and they don't like to
> share.
>
> As you say, manual subsets are not cost effective because of the DBA effort
> involved in making them. If you have an automated tool that just snips out
> subsets like a cookie cutter then you can have as many as you care to.
>
> Cheers
> Dale Edgar
> Net 2000 Ltd.
> Dale_at_DataBee.com
> DataBee: http://www.databee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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 Sat Jan 19 2002 - 12:10:24 CST

Original text of this message

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