From oracle-l-bounce@freelists.org Mon Mar 1 13:57:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21JvQY27769 for ; Mon, 1 Mar 2004 13:57:26 -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 i21JvQo27764 for ; Mon, 1 Mar 2004 13:57:26 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 324C4394CCA; Mon, 1 Mar 2004 14:58:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 14:57:01 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from web10010.mail.yahoo.com (web10010.mail.yahoo.com [216.136.128.121]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id CE9613952CF for ; Mon, 1 Mar 2004 14:56:57 -0500 (EST) Message-ID: <20040301200031.92029.qmail@web10010.mail.yahoo.com> Received: from [209.180.88.72] by web10010.mail.yahoo.com via HTTP; Mon, 01 Mar 2004 12:00:31 PST Date: Mon, 1 Mar 2004 12:00:31 -0800 (PST) From: Tapan Trivedi Subject: Re: Methods to Create Smaller Test DB from Production? To: oracle-l@freelists.org In-Reply-To: <001301c3ffc4$0d2e5900$2501a8c0@dazasoftware.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-895985558-1078171231=:86488" X-archive-position: 170 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: taptriv@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --0-895985558-1078171231=:86488 Content-Type: text/plain; charset=us-ascii David, We have, in the past, used Databee's free tool successfully to load the subset into the database. Alternatively TOAD also has a little subset tool which is not that functional. But Databee with scripts is, in my opinion , the easiest way to go. My 0.02 $ Tapan Trivedi ----- Original Message ----- From: David Wagoner To: ORACLE-L (E-mail) 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... What is a good method to create a smaller test database from Production? 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, David B. Wagoner Database Administrator ---------------------------------------------------------------- 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 ----------------------------------------------------------------- --0-895985558-1078171231=:86488 Content-Type: text/html; charset=us-ascii

David,

We have, in the past, used Databee's free tool successfully to load the subset into the database. Alternatively TOAD also has a little subset tool which is not that functional. But Databee with scripts is, in my opinion , the easiest way to go.

My 0.02 $

Tapan Trivedi

 

----- Original Message -----
From: David Wagoner <mailto:dwagoner@arsenaldigital.com> 
To: ORACLE-L  <mailto:oracle-l@freelists.org> (E-mail)
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...

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

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,

David B. Wagoner
Database Administrator

----------------------------------------------------------------
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
-----------------------------------------------------------------

--0-895985558-1078171231=:86488-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------