ciapecki wrote:
> 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
If you have 10g you are trying to reinvent the wheel. Take a look at
DBMS_CHANGE_NOTIFICATION. Docs at tahiti.oracle.com and demos at
http://www.psoug.org/reference/dbms_change_notification.html
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 15 2007 - 19:27:15 CDT
