Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Trace who remove dba_jobs
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
![]() |
![]() |