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 -> Re: recover lost triggers

Re: recover lost triggers

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 19 Jun 2007 19:32:02 -0000
Message-ID: <1182281522.270627.239410@c77g2000hse.googlegroups.com>


On Jun 19, 3:16 pm, rich <rschn..._at_nsf.gov> wrote:
> Sybrand, so you are telling me that the triggers, although they are in
> the old unix backup, it is not possible to read them out of there with
> anything readily available to me?
>
> Rich S.

Hi Rich,

It ouwl dbe unreliable and messy as all get out, but you could try a "strings -a | grep -i trigger" against any files named system*dbf (if they followed standards). That is one way you *may* be able to extract some of the trigger text.

HTH, Steve Received on Tue Jun 19 2007 - 14:32:02 CDT

Original text of this message

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