TechView with Kamlesh khaliya

Resources for OCP, Oracle Interviews(kamleshkhaliya@gmail.com)

Friday, 8 July 2011

How to recompile a trigger in oracle?

If you want to recompile an existing trigger on your own schema you just need to write the statement like :
ALTER TRIGGER trigger_name COMPILE;

Or if you have the write on the triggers of another schema and want to recompile it then :

ALTER TRIGGER schema.trigger_name COMPILE;

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home