I have a table in ORACLE with primary key id. I have cached the table in extreme scale.
Now i want to update my cache based on updates on the database.Time based update works fine but for this application I want to use database triggers to update the cache.
I am able to genertae a trigger on any row change .The trigger passes the RowID psuedo column of oracle and the operation type .
can i use the ROWID(psuedo column) as a key to update my cache.
If yes please illustrate how I can achieve this.and how will my cache entry identify the row id.