| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Subset Tool?
Larry,
Some time ago Mladen Gogala had posted about a tool (Move For Servers) from
Princeton Softech.
Here is the link :
http://www.princetonsoftech.com/products/moveforservers.asp
We are looking into this product as well.
HTH,
Regards,
- Kirti
-----Original Message-----
Sent: Friday, January 18, 2002 7:25 PM
To: Multiple recipients of list ORACLE-L
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).
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 - 20:16:59 CST
 |
 |