Home » SQL & PL/SQL » SQL & PL/SQL » how to check whenever package got modified (Oracle 10g)
how to check whenever package got modified [message #401840] Wed, 06 May 2009 11:14 Go to next message
spsbombay
Messages: 29
Registered: June 2007
Junior Member

Hello,

Could you please advice, is there any log table, where i can see when did any object gets modified. I need all the changes, not only the last_ddl_time.

Also it would be great, if i can get the changes.

Thanks for your attention.
Regards,
Prashant
Re: how to check whenever package got modified [message #401842 is a reply to message #401840] Wed, 06 May 2009 11:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That would by your change control software that holds that sort of thing.
Oracle itself only holds the Created Date, Last DDL time (time the code was last compiled) and Timestame (Time the code signature last changed)

If you've got Logminer or Flashback set up, then I think you can use that to see what changes have happened to a procedure, but I wouldn't swear to it.

Really - this is why you use change control software.
Re: how to check whenever package got modified [message #401844 is a reply to message #401840] Wed, 06 May 2009 11:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is none.
You have to activate audit.

Regards
Michel
Previous Topic: ROWID differences
Next Topic: concatinating similar rows
Goto Forum:
  


Current Time: Sun Dec 04 04:34:07 CST 2016

Total time taken to generate the page: 0.10944 seconds