From oracle-l-bounce@freelists.org Mon Mar 1 12:45:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21IjOr14116 for ; Mon, 1 Mar 2004 12:45: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 i21IjOo14110 for ; Mon, 1 Mar 2004 12:45:24 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5EAD83950F7; Mon, 1 Mar 2004 13:45:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 13:44:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3A925394FEC for ; Mon, 1 Mar 2004 13:44:40 -0500 (EST) Received: (qmail 27345 invoked from network); 1 Mar 2004 18:44:01 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 1 Mar 2004 18:44:01 -0000 Message-ID: <006501c3ffbd$268a3740$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: References: Subject: Re: Methods to Create Smaller Test DB from Production? Date: Mon, 1 Mar 2004 14:43:35 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0060_01C3FF9B.93B1C260" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 139 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0060_01C3FF9B.93B1C260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Methods to Create Smaller Test DB from Production?You can copy the = production database, the optimal You can delete records, and make this faster, and export import = statistics to get performance test more accurate to reality. ----- Original Message -----=20 From: David Wagoner=20 To: ORACLE-L (E-mail)=20 Sent: Monday, March 01, 2004 2:37 PM Subject: Methods to Create Smaller Test DB from Production? I know many of you have addressed this same issue...=20 What is a good method to create a smaller test database from = Production?=20 I've read about the commercial product called DataBee for doing this, = but what other methods are you guys using? With all of the expertise in = this list, there are bound to be some interesting solutions. Best regards,=20 David B. Wagoner=20 Database Administrator=20 ------=_NextPart_000_0060_01C3FF9B.93B1C260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Methods to Create Smaller Test DB from = Production?
You can copy the production database, the = optimal
You can delete records, and make this faster,=20 and export import statistics to get performance = test more=20 accurate to reality.
 
----- Original Message -----
From:=20 David Wagoner
Sent: Monday, March 01, 2004 = 2:37=20 PM
Subject: Methods to Create = Smaller Test=20 DB from Production?

I know many of you have addressed this = same=20 issue...

What is a good method to create a = smaller test=20 database from Production?

I've read about the commercial product = called=20 DataBee for doing this, but what other methods are you guys = using?  With=20 all of the expertise in this list, there are bound to be some = interesting=20 solutions.


Best regards,

David B. Wagoner
Database Administrator

------=_NextPart_000_0060_01C3FF9B.93B1C260-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------