RE: Porting test rows to a Development instance...

Some shops might be sensitive about production data in a test environment so they might copy data from proid db to test db and then apply some scripts to modify data in test.

Long

-----Original Message-----
From: Larry Holder [mailto:lholder_at_utm.edu] Sent: Tuesday, 8 August 2000 9:16 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Porting test rows to a Development instance...

>> We have an ongoing issue in our shop that is causing everyone
headaches.
>> The issue involves porting an ample amount of test data from, say our
>> Production instance down to our Development instance to adequately test
our
>> customizations. John Mule'

>> Oracle

Development Team
>> Tulane

University
>> (504)

862-8000 ext. 2574

John,
We periodically re-clone our Testing instance from our Production instance. Full-sized, nothing left out. Can't beat that for testing with. Worth the disk space. In fact, I have two full-sized non-production instances, one for users to train and experiment with, and one just for me as DBA to work on (testing backups, etc).

Larry Holder
Senior Systems Analyst, Oracle Database Administrator The University of Tennessee at Martin Computer Center lholder_at_utm.edu (901) 587-7890 www.utm.edu/~lholder Saved by grace <>< Romans 8:38-39

-- 
Author: Larry Holder
  INET: lholder_at_utm.edu

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: ListGuru_at_fatcity.com (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).