Re: hash value - function

On 14 Aug., 19:50, Brian Peasland <d..._at_nospam.peasland.net> 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.nethttp://www.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 fromhttp://www.teranews.com

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 Received on Wed Aug 15 2007 - 16:06:44 CDT