Re: Data Subset Tool?

Larry,

Disk is cheaper. :)

Jared

On Friday 18 January 2002 17:25, Larry Elkins wrote:
> Listers,
>
> I know this subject has been brought up before, and I will go through the
> archives as well as pull out the Google Gun, but does anyone have
> recommendations on a tool that will create a subset of production data that
> is referentially intact? I am aware of DataBee (which Mark mentioned the
> other day), and I'm sure I will turn up some others.
>
> I know it can be built by hand, but it might be more cost effective to buy
> something if the price is right. The main feature I would be interested in
> is a tool that maintained the distribution characteristics of the data. For
> example, assume production has 20 years worth of data. For a query
> specifying various criteria, criteria against a date range of a month would
> be very selective (assuming even distribution). Now, if you throw only 2
> years in the development environment, a different plan using criteria other
> than a month date range, maybe even a different driving table, might be
> better. So you now have a case where one plan is better in DEV and a
> different plan is better in PROD. An age old problem I'm sure lots of us
> have dealt with.
>
> Regards,
>
> Larry G. Elkins
> elkinsl_at_flash.net
> 214.954.1781

-- 
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).