Ref:(Data file last alter date)

Hi,

Like 'Last_DDL_Time' column in all_objects, is there any way to know when the datafile is altered?.

Thanks,

Sure. Look at the timestamp in the directory listing in the OS.

Quote:

---

Originally posted by tombest
Sure. Look at the timestamp in the directory listing in the OS.

---

Do you know what will OS do when data is added or deleted from datafile?

Hi,

Yes, if I look at the os time stamp it indicates today's date and time, but I altered the datafile on 18th of this month.

Thanks,

what do you exectly mean by "I altered the datafile" ?
What do you exactly want to see?

Hi,

I have resized the datafile on 18th of this month, I would like to see the datafile last altered date (i.e., 18-JUL-2003), which database object provides that information.

Thanks,

Check alert.log