-
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
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
|