Data Subset Tool?

From: Larry Elkins <elkinsl_at_flash.net>
Date: Fri, 18 Jan 2002 17:52:26 -0800
Message-ID: <F001.003F4A48.20020118172517@fatcity.com>

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: Larry Elkins
INET: elkinsl_at_flash.net

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 Jan 18 2002 - 19:52:26 CST