• No replies
1485 Posts

Pinned topic Using RowID in oracle as key

‏2013-03-05T16:30:30Z |
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.