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: Larry Elkins 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).
