One more thing: If you do it on a timely basis (daily, weekly) then people who need data that can be satisfied by it does not need to use the production database. Also developers like to test against a live like database. This way they are more likely to catch errors when working against transactions that are very seldom used.
Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]] > Sent: Thu, March 14, 2002 5:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Poll & Questions > > > Clarification: My initial question was not really asking how to do it. > But > more it was trying to find out what other shops do. In addition, since > the > production database is large what benefits/costs can I present to justify > cloning a fullsized database to an acceptance database? > > For example, I think it is far easier to copy the entire database rather > than > extract some subset of it for creating a sizable acceptance database. > Also, I > think we would obtain more accurate timings for queries in an exact copy > rather > than a subset of data. What else? > > > > > > 03/13/2002 10:38 AM PST > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > cc: > > > We do a similar refresh (as mentioned by Kirti) daily using hotbackup and > archivelogs and it is named DAYOLD. > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN > Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----Original Message----- > Sent: Wednesday, March 13, 2002 12:24 PM > To: Multiple recipients of list ORACLE-L > > > Kirti, > > Why not using "hot" backup + archived log files ? Just wondering, if there > is any specific reason. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > (See attached file: ESPN_Disclaimer.txt) > > > *** eSafe scanned this email for malicious content *** > *** IMPORTANT: Do not open attachments from unrecognized senders *** << > File: ESPN_Disclaimer.txt >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).