Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Trace who remove dba_jobs

Trace who remove dba_jobs

From: Sinardy Xing <oracle.rdbms_at_gmail.com>
Date: Wed, 20 Sep 2006 11:30:35 +0800
Message-ID: <f52c14170609192030v5fd82fc9n6513e3d1665e56b0@mail.gmail.com>


Hi guys,

I have "CSI" task need to discuss with you.

Some one remove dba_jobs, it is Oracle 8i how can I know who remove the job and what time,

I have collected:
1. Complete listener.log
2. I tried to select * from v$sql and v$sql_are where sql_text like dbms_job.remove but find nothing.
3. no audit :(
4. no archive can't do log mining :(

--

regards,

Sinardy

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 19 2006 - 22:30:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US