Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> recover lost triggers

recover lost triggers

From: rich <rschneid_at_nsf.gov>
Date: Tue, 19 Jun 2007 11:23:49 -0700
Message-ID: <1182277429.223089.71640@p77g2000hsh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US