Re: WHO DID IT?

Not unless you have some kind of auditting on for that table.

Other then that you can query v$sqlarea and v$sqltext views and link them to v$session if the user is still logged in. Otherwise v$opencursors might aid your cause too.

HTH Lyall Barbour

At 02:47 PM 8/16/00 -0800, you wrote:

>a production database has misteriously lost all of its data...I can
>re-create it
>from backup but before I do I'd like to find out who was the last person to
>access certain tables in order to find out who truncated everything...does
>anyone have a method to find the culprit?
>
>thanks in advance...
>super-sluth...:)
>
>--
>Author: Roy Ferguson
> INET: rferguso_at_level1.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 Wed Aug 16 2000 - 17:54:57 CDT