RE: How to refresh

Ron - As far as losing the new functions, this is one reason we've moved to a 3-instance layout. Production, staging, and test. This takes off a lot of the pressure for overwriting test as you describe. Other than that, it becomes a matter of negotiation. Describe what your options are, and let them decide which option they choose. Also suggest that everything in test
(except maybe data changes users have made) should be based on scripts. If
they've created functions, they should have scripts to recreate those because that is what they are eventually going to have to do in production
(or in staging, if you implement that).

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, December 16, 2003 8:59 AM To: 'ORACLE-L_at_fatcity.com'

Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact replica in all respects, and you can test your backup as a bonus. If you are interested in this method, tell us how you backup your production database.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, December 16, 2003 8:55 AM To: Multiple recipients of list ORACLE-L

I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import.

Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints?

Thanks!
Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).