Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find who compiled a object manually

User_PT6OPJun 6 2014 — edited Jun 6 2014

Hello All,

I have a question which I am not able to figure out.

How would we know if any particulaar object ( table,view , package, procedure function etc)

is compiled by anyone?

I know in all_objects LAST_DDL_TIME will give me the last modified objects time.

But in my case there are more than 2000 objects that were modified for today's date.

so I want to figure out who modified or compiled any object manually. Please help on this.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2014

Added on Jun 6 2014

#general-database-discussions

7 comments

6,448 views