Home » SQL & PL/SQL » SQL & PL/SQL » Trigger lost when View Re-Created (RHEL 4, Oracle10g)
Trigger lost when View Re-Created [message #380747] Tue, 13 January 2009 03:52 Go to next message
srikanth2384
Messages: 4
Registered: December 2008
Location: Pune
Junior Member

Hi All,

I had written INSTEAD OF INSERT OR UPDATE trigger on a view and compiled it successfully.

Today by mistake view has been re-created and the existing trigger on it is lost.

Is there any way to get the previous trigger back? Confused
Please advice me what can be done to get the old trigger back.

Thanks.

~Srikanth
Re: Trigger lost when View Re-Created [message #380749 is a reply to message #380747] Tue, 13 January 2009 03:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Get the code for the trigger back out of your source control software.

Re: Trigger lost when View Re-Created [message #380750 is a reply to message #380747] Tue, 13 January 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Take it from your source repository.

Regards
Michel
Re: Trigger lost when View Re-Created [message #381032 is a reply to message #380750] Wed, 14 January 2009 23:05 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
If you have no source repository (shame shame), ask your dba to restore your database from a backup known to have the trigger, then extract it.

hehe, restore a database just to get a trigger back. Well, its been done to get tables back, I supposed triggers is OK too.

Good luck, Kevin
Previous Topic: normalization question need for nullable column ?
Next Topic: What may be problem?
Goto Forum:
  


Current Time: Sat Feb 08 16:50:36 CST 2025