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 > [EMAIL PROTECTED] > 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
