Wish you all a very happy new year 2002..
Where can we see the creation date/time for a datafile?
Any dictionary view/table?
Thanks in advance
You can find the same by using the following query
select file#,name ,creation_time,creation_change#,status,
create_bytes from v$datafile
it is in 8i.
Is there any way I can find out in Oracle 126.96.36.199.0
I have taken a quick look at ORacle 188.8.131.52 system views but I didn't find one with the datafile creation date.
If you have not deleted the alert file, you can find the datafile creation date.
Hope this helps
Execute the following while connected as SYS:
select fe.indx+1 "File#", fe.fecrc_tim "Creation Date", fn.fnnam "Datafile Name"
from x$kccfe fe, x$kccfn fn
where fe.indx+1 = fn.fnfno and fn.fntyp=3;
Click Here to Expand Forum to Full Width