From oracle-l-bounce@freelists.org Mon Mar 1 13:51:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21JpOH26648 for ; Mon, 1 Mar 2004 13:51:24 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i21JpOo26643 for ; Mon, 1 Mar 2004 13:51:24 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6FC2C3951C7; Mon, 1 Mar 2004 14:51:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 14:50:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail5.utc.com (mail5.utc.com [192.249.46.188]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22B7A3950C6 for ; Mon, 1 Mar 2004 14:50:37 -0500 (EST) Received: (from uucp@localhost) by mail5.utc.com (8.10.0/8.10.0) id i21Jqjr23074 for ; Mon, 1 Mar 2004 14:52:45 -0500 (EST) Received: from uusnwa0p.utc.com(159.82.80.106) by mail5.utc.com via csmap (V6.0) id srcAAAOwaqcT; Mon, 1 Mar 04 14:52:44 -0500 Received: from carussyrmc03.carrier.utc.com (carussyrmc03.carrier.utc.com [161.145.120.80]) by uusnwa0p.utc.com (Switch-2.2.8/Switch-2.2.8) with ESMTP id i21Js7F03833 for ; Mon, 1 Mar 2004 14:54:07 -0500 (EST) Received: by carussyrmc03.carrier.utc.com with Internet Mail Service (5.5.2657.72) id <1LX75TFL>; Mon, 1 Mar 2004 14:53:09 -0500 Message-ID: <590E1FF8B6A4D4118CB200508B63D23E0D784350@carussyrmb01.carrier.utc.com> From: "Thater, William" To: "'oracle-l@freelists.org'" Subject: RE: Methods to Create Smaller Test DB from Production? Date: Mon, 1 Mar 2004 14:54:05 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FFC6.F4032480" X-Scanned-By: MIMEDefang 2.39 X-archive-position: 167 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: William.Thater@carrier.utc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FFC6.F4032480 Content-Type: text/plain; charset="ISO-8859-1" -----Original Message----- From: Mercadante, Thomas F [mailto:thomas.mercadante@labor.state.ny.us] Sent: Monday, March 01, 2004 2:48 PM To: 'oracle-l@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@carrier.utc.com ------------------------------------------------------------------------ Absence is to love what wind is to fire; it extinguishes the small, it enkindles the great. - Comte de Bussy-Rabutin ------_=_NextPart_001_01C3FFC6.F4032480 Content-Type: text/html; charset="ISO-8859-1" RE: Methods to Create Smaller Test DB from Production?
 
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@labor.state.ny.us]
Sent: Monday, March 01, 2004 2:48 PM
To: 'oracle-l@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@carrier.utc.com
------------------------------------------------------------------------
Absence is to love what wind is to fire; it extinguishes the small, it enkindles the great. - Comte de Bussy-Rabutin
 
------_=_NextPart_001_01C3FFC6.F4032480-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------