trigger on commit
Hi
BUILD IMMEDIATE REFRESH FORCE ON COMMIT WITH PRIMARY KEY
AS
SELECT yy, COUNT (*)
FROM yy
WHERE 1 = 2
GROUP BY acc;ThanksShraga
Do you have any idea how to fire trigger on commmit statement
I tried to do it via MV with force on commit
it is working good but there is a lot of JI locking on concurrent sessions
i created the MV like the folowing
CREATE MATERIALIZED VIEW xx TABLESPACE xx LOGGING NOPARALLELBUILD IMMEDIATE REFRESH FORCE ON COMMIT WITH PRIMARY KEY
AS
SELECT yy, COUNT (*)
FROM yy
WHERE 1 = 2
GROUP BY acc;ThanksShraga
0