RE: Methods to Create Smaller Test DB from Production?

From: Thater, William <William.Thater_at_carrier.utc.com>
Date: Mon, 1 Mar 2004 14:54:05 -0500
Message-ID: <590E1FF8B6A4D4118CB200508B63D23E0D784350@carussyrmb01.carrier.utc.com>

-----Original Message-----

From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Monday, March 01, 2004 2:48 PM
To: 'oracle-l_at_freelists.org'
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_at_carrier.utc.com

<mailto:william.thater_at_carrier.utc.com>

Absence is to love what wind is to fire; it extinguishes the small, it enkindles the great. - Comte de Bussy-Rabutin

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 13:51:27 CST