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

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Help - how to track from dictionaries when the view definitions have been redefined/recompiled

Re: Urgent Help - how to track from dictionaries when the view definitions have been redefined/recompiled

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 21 Aug 2003 22:33:52 -0700
Message-ID: <73e20c6c.0308212133.31870f10@posting.google.com> 





avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0308211517.7b36b75a_at_posting.google.com>...



> Any clue if i can track from the database, when the views and by whom

> they got recompiled/redefined.. it will be helpful for me to track. I




Without explicit auditing being enabled, you can get some 
information from dba_objects view: it will show timestamp
of last ddl change.



Cheers


Nuno Souto


wizofoz2k_at_yahoo.com.au.nospam
Received on Fri Aug 22 2003 - 00:33:52 CDT












Original text of this message













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