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;
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