Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Determine if Table Modified
You can query the obj view:
select object_name,object_type,created,last_ddl_time from obj where object_ name like 'S%'
HTH Richard Chen
George cova wrote:
> How can I determined if an Oracle table was modified. In other words, I
> would like to know if a record was entered, deleted,or modified. Is there
> something in the Dictionary that I can query that will tell me like the last
> dateTime table modified? Or maybe some other field or value that counts the
> number of times table was modified?
>
> The reason I need to find if table was modified is because I'm caching a
> small Oracle table on a web server and I only want to refresh the cache if
> necessary. So, before returning records from the small table from the
> database, I can just first check it to see if it was modified.
>
> I'm currently checking the record count ( select count(1) from myTable) to
> determine if any records were added or deleted since the last time I checked
> it. The problem with this method is that is a record is modified, the count
> stays the same and my code does not attempt to refresh the cache.
>
> Any help would be appreciated.
>
> Thanks, George
Received on Sun Sep 03 2000 - 08:59:06 CDT