Best practice for backing out of Application Patches

2002-12-03 Thread Scott Stefick
Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm

RE: Best practice for backing out of Application Patches

2002-12-03 Thread Mercadante, Thomas F
Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used

RE: Best practice for backing out of Application Patches

2002-12-03 Thread Scott Stefick
Thanks to Thomas Mercadante, Stephen Lee and Rick Cale for their responses. I think it's pretty unanimous that if this needs to be done, I would just restore to the point in time taken right before the patches were installed. Either I could do an export/restore/import or refresh from the