the trigger isn't that expensive...
last_update_dt and Last_update_user
- Yechiel Adar <adar76_at_inter.net.il> wrote:
> When a developer wants to change a table it helps if
> we know who is using it. Sometimes there are applications
> that use tables that belong to other applications
> and nobody remembers. Than we change the table
> and KABOOM
> (as expressed by the Martian that
> Bugs Bunny fought and of course according
> to the application people
> an earth shuttering KABOOM :-) ).
>
> We need idea how to do it. We thought about auditing
> of writing a trigger that will log each access to the
> table but we fear the overhead.
>
> Any suggestions, ideas, whatever are welcome.
>
> TIA
>
> Yechiel Adar
> Mehish
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Aug 13 2002 - 12:05:04 CDT