Trace who remove dba_jobs

  • From: "Sinardy Xing" <oracle.rdbms@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 20 Sep 2006 11:30:35 +0800

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 :(



Other related posts: