Creation date for a datafile?

Hi all,

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

Sanjay

Hi

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.

Thanks Murugappan,

Is there any way I can find out in Oracle 7.3.4.5.0

Sanjay

Hello,

I have taken a quick look at ORacle 7.3.4.5 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

Regards

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;


-amar

Thanks Amar,

Got it...

..Sanjay