Re: finding the base tables for v_$session

"Peter Shankey" <shankeyp_at_its.charlestoncounty.org> wrote in message news:20010619.20481200_at_wando.charlestoncounty.org... I need to create a trigger to do some auditing type stuff. I would like to create a trigger. Any ideas?

1 You can't create triggers on v$ views as they are in memory views. Oracle will return an error
2 Oracle already has an auditing facility. If you think you can't use it, could you please specify what you try to accomplish 3 As many others you fail to specify which version you are using. Oracle 8i has new triggering events, which could easily be used to do custom auditing.

Hth,
Sybrand Bakker, Oracle DBA Received on Tue Jun 19 2001 - 16:45:04 CDT