Actually we get a bunch of scripts from different teams (for different
schema owners) to be run. Unless there are dependencies we put them in a
directory. A Perl script scans the directory for files and creates a run
script. The format for each script is as follows ...
--
prompt Connecting tcs_at_NCS
prompt Executing 33866_02_tcs.sql
conn tcs/db20021113_at_NCS
set feedback on
spool 33866_02_tcs_NCS.log
@33866_02_tcs.sql
spool off
Prompt Pausing ... hit return to continue ...
pause
These code blocks repeat ... the filename is of the type
<SR>_<SEQ>_<SCHEMA>.sql ... so we can sequence multiple files for one SR ...
We change all schema owner passwords to a knows value before applying
changes and re-set them back after all changes have been applied. We have
the code in PVCS but my question is how to work on getting the "undo"
scripts if something gets screwed ...
We have a (kind of) UAT environment ... the situation is much more dynamic
...
Thanks in advance
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, November 13, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L
Raj - Can you provide more details? Is this an automated script, or just a
line on the form that says that you have some idea of how to rollback the
change in case anything goes wrong?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jamadagni, Rajendra
INET: Rajendra.Jamadagni_at_espn.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).
Received on Wed Nov 13 2002 - 11:54:41 CST
