| how to check whenever package got modified [message #401840] |
Wed, 06 May 2009 11:14  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
