-
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.
Tom Best
-
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?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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,
-
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|