| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to refresh
If the developers have code in dev they should have DDLs that generate the
triggers and changes. I hate it whenDevelopers think they can get away with
telling some else to own thier code...Database CODE in my mind always
includes the scripts to generate the object in addition to the funtioning
body of the code. If they don't then crack the whip and whip those fellows
into shape. They shouldn't be just generating changes without code to effect
the change....sheesh...
If they refuse to do thier job correctly then why not run OEM's change management db compare bewteen prod and dev to generate the object changes in a script that you can run after the produciton import.
THough you are opening yourself up to being reponsible for code you didn't write.
Brad
-----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).
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). Received on Tue Dec 16 2003 - 10:39:25 CST
 |
 |