It does exist. Take a look at Princeton Softech, http://www.princetonsoftech.com Very good tool, very good company. Alternatively, there is a UK company called DataBee, which does the same thing. I don't have much experience with them, but thweir DBA Tool to extract DDL from an export file is excellent. You can look at them at http://www.databee.com On 03/01/2004 02:54:05 PM, "Thater, William" wrote: > > > -----Original Message----- > From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx] > Sent: Monday, March 01, 2004 2:48 PM > To: 'oracle-l@xxxxxxxxxxxxx' > Subject: RE: Methods to Create Smaller Test DB from Production? > > > David, > > Boy, this would be a great tool if it existed. > > I think the only way out for you is to roll-your-own. You could easily > identify code tables (look-up tables) and export all of that data. But the > relational data (like your main parent table and all of the subsequent > children records) you will probably need to move by hand - or by writing a > program to select, say, 10,000 master records and all of the subsequent > child records. It's not an easy task, but once you've done it, it is in the > can - but subject to updates when new tables and relationships come along. > > Good Luck! > [Shrek] > > there is a product from Quest that will do that for PeopleSoft, i used it on > my previous gig to do just that. but i don't know if it will work with > databases other than PeopleSoft. > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > william.thater@xxxxxxxxxxxxxxx > <mailto:william.thater@xxxxxxxxxxxxxxx> > ------------------------------------------------------------------------ > Absence is to love what wind is to fire; it extinguishes the small, it > enkindles the great. - Comte de Bussy-Rabutin > > > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------