Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: hash value - function

Re: hash value - function

From: DA Morgan <>
Date: Wed, 15 Aug 2007 17:27:15 -0700
Message-ID: <>

ciapecki wrote:
> On 14 Aug., 19:50, Brian Peasland <> wrote:

>>> I wanted to use this procedure to check periodically if a table
>>> changed.
>>> I would save the original hash value, and run periodically checks on
>>> the table if the hash value is different,
>>> if it is the case it means the content of the table changed.
>> Do you want to guard against changes to the table? If so, put the table
>> in a READ ONLY tablespace.
>> If you just want to know *if* the table has been changed, then implement
>> auditing on the table. You'll not only know *if*, but *when* and *who*
>> as well.
>> HTH,
>> Brian
>> --
>> ===================================================================
>> Brian Peasland
>> d...@nospam.peasland.net
>> Remove the "nospam." from the email address to email me.
>> "I can give it to you cheap, quick, and good.
>> Now pick two out of the three" - Unknown
>> --
>> Posted via a free Usenet account from

> Hi there,
> I don't want to guard against changes.
> Changes are allowed,
> I just want to run my action whenever the table changed (my action
> creates a kind of report - only when something new appears in the
> table).
> The table I am talking about is quite small around 5k rows with 6
> columns (varchar2(50)).
> USER_TAB_MODIFICATIONS view might actually solve my problem in an
> easier way, but the table is not in my schema, and I have no rights to
> look inside of TAB_MODIFICATIONS of that table.
> That's why I thought instead of running everyday my report I will
> check first if there were any changes, that's why I thought hash value
> might be a good start.
> thanks
> chris

If you have 10g you are trying to reinvent the wheel. Take a look at DBMS_CHANGE_NOTIFICATION. Docs at and demos at

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Aug 15 2007 - 19:27:15 CDT

Original text of this message