how to find out that how many times trigger fired today [message #301934] |
Fri, 22 February 2008 06:22  |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
Could you please me in finding out that how many times triggers have been fired.
Actually we are replicating our table on hourly basis from sql server 2000 to Oracle 10g.(Performing Transactional replication)
After replication, trigger on table will be activated which will insert the row in other table.
We want to check that replication is working fine or not in oracle side as sql server is pushing records to us and i am not authorize to access that sql server
|
|
|
|
|
Re: how to find out that how many times trigger fired today [message #301969 is a reply to message #301940] |
Fri, 22 February 2008 09:22   |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
Triggers on table are created mainly in three event Insert, Update and delete
and It can be before,after the above events.
Trigger can be row level or it can be statement level trigger
Example of one simple trigger is
create or replace trigger <trigger name>
after insert on <tablename>
for each row
declare
declare variable here
begin
statements
end;
|
|
|
|
|