Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> recover lost triggers
Hello all, I have joined a project which used to have a bunch of
triggers. At some point prior to my arrival, some key tables (which
had triggers) were dropped and re-created. However, the triggers
never got recreated. They were not doing oracle wise backups.
Sysadmin was just backing up all of the unix file systems. Now they
have restored the backup (100GB +-) to the unix system. Noone wants
to restore this old system over the new one. Is there a way for me to
find the trigger text in this mass of unix files? Where or where are
the triggers?
Rich Schneider Received on Tue Jun 19 2007 - 13:23:49 CDT