| Compile Triggers [message #78739] |
Wed, 13 March 2002 09:35  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
Hello all,
I am about to delete a bunch of code out of a whole pile of triggers (audit inserts into history tables). I want to leave all the other code in the triggers and then recompile them... How could I write a script to recompile the triggers... I know that there is ALTER PROCEDURE name COMPILE; or ALTER FUNCTION name COMPILE; But I can't seem to find ALTER TRIGGER name COMPILE;....SUGGESTIONS?
T
|
|
|
|
| Re: Compile Triggers [message #78746 is a reply to message #78739] |
Wed, 13 March 2002 23:52  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
when u delete the code from the trigger u have to run the code again ,at this time it will automatically compiled.
e.g.
old trigger
----------
create or replace trigger....
...
begin
line1;
line2;
end;
let us take line2 out.so
new trigger
-----------
create or replace trigger....
...
begin
line1;
end;
to make this changes to database u have to run the above code, at that time it will automatically compiled.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
