Creation date for a datafile?

[SANJAY_G]

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

[murugappan]

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.

[SANJAY_G]

Thanks Murugappan,

Is there any way I can find out in Oracle 7.3.4.5.0

Sanjay

[noor]

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

[amar]

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

[SANJAY_G]

Thanks Amar,

Got it...

..Sanjay