I need help on tracking any DML operation done on my schema.
For example if I have few tables on schema "ABC":
Now any insert, update , delete queries executed on my schema should be captured.
I have a table called :
-- Created to track the DML openration done on one schema
CREATE TABLE ms_sra_dml_log (
SERVER_TIME timestamp (6) with time zone,
SESSION_TIME TIMESTAMP (6) WITH TIME ZONE,
Now I want to create one trigger which should capture any changes on those tables.