Triggering events for the Lost Triggers!!! Going Nuts....
567066Apr 10 2008 — edited Apr 11 2008Gurus,
Oracle ver 11g
I am going nuts and crazy here....
Can you think of any possible reasons that I have lost all my objects that I created for triggers ( approx 65 objects) and how to get back those objects.
I don't have the script to re-create all those objects again as I did it manually using the Toad and I am 1005 sure I saw all the objects created and was able to see them in sql*developer tool.
We had a server crash and we had to reboot the server where this oracle is residing, but other than that I am have no reason how the objects disappeared...
My belief is create trigger is a DDL command Right? so the objects should be there in the DB.but I am not able to see them any possible reasons>?? please advice when time permits
Thanks
Sheik