RE: Methods to Create Smaller Test DB from Production?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 1 Mar 2004 13:12:01 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00093@EXCHMN3>

David - I disagree. I feel that your energy is better expended in creating test databases by recovering your production backup. You do test your backups, don't you? When we have created subset databases, the testing often failed to reveal problems, or the users would become frustrated with missing data. Just my 2 cents worth.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Wagoner
Sent: Monday, March 01, 2004 1:06 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Methods to Create Smaller Test DB from Production?

Juan,

Unfortunately, that solution requires that you have enough disk space to hold an entire copy of production, not to mention the archive logs that will be generated by deleting data.

I'm looking for clever solutions to this problem. I suppose writing your own referentially-correct ETL from Production to Test is one way. That's sort of what the DataBee product does, I think. Subsetting a production DB for test would be an excellent new feature for 10g!

Best regards,

David B. Wagoner
Database Administrator

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

From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com] Sent: Monday, March 01, 2004 1:44 PM
To: oracle-l_at_freelists.org
Subject: Re: 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 ----- From: David Wagoner <mailto:dwagoner_at_arsenaldigital.com> To: ORACLE-L <mailto:oracle-l_at_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_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:11:35 CST