HELP

how do i figure out the last time a database was last modified and by whom?

When you say database do you mean a tablespace or do you mean an individual object ?

Slaine

Hi!

You should turn on audit. You can get time from modified datafile and only but cannot find username without audit.

Sergey.

both

Hmm
I don't know what performance degradation you may get if you turn on auditing if any

The is a column in DBA_OBJECTS called LAST_DDL_TIME but I don't know if this is the actual time the dictionary version of the object has changed. It would be incredibly long winded if you wanted to see whenever anyone inserted a row.

As for a tablespace you can look at the timestamp of the datafile if it has been added I do however have a script somewhere that shows the last modification to a tablespace
I'll try and dig it out and send me your Email

Cheers
Slaine

thanks Slaine i would appreciate that

Chrissy

I need an Email address to send the script to

Slaine

Hi Chrissy

If you need to know When object was created
and When it was modified last time you may use the following script.

http://www.geocities.com/ageldutes/s...ject_info.html

ageldutes I think Slaine already suggested that :o

If you want to figure out when the data changed, you will have to write some elaborate triggers that spool all the changes to an audit trail.

Otherwise, if you are on 8i, you can use the logminer functionality to dig through the logfiles for your audit trail.