Re: ***Help! System Table Space Data

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 7 Mar 1999 09:31:46 GMT
Message-ID: <7bth22$ej6$4@news.seed.net.tw>

Haruka Suko ¼¶¼g©ó¤å³¹ <7br786$e1a_at_bgtnsc02.worldnet.att.net>...
>Hello!
>How can I know the full path name(s) of the Oracle database file(s) that
>contain the system tablespace data? Also, what's the SQL to get
information
>about the date that each file was created?
>Thank you so much!

SELECT FILE_NAME FROM SYS.DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSTEM'; As I know, Oracle does not record the date info of datafiles. You should use OS command to get the date info. Received on Sun Mar 07 1999 - 03:31:46 CST