datafile added date
datafile added
select file_id, fecrc_tim creation_date, file_name, tablespace_name
from x$kccfe int, dba_data_files dba
where dba.file_id = int.indx + 1
order by file_id
FILE_ID CREATION_DATE FILE_NAME TABLESPACE_NAME
------- -------------------- -------------------------------------------------- ------------------------------
1 08/15/2009 00:16:48 /opt/app/oracle/oradata/orcl/system01.dbf SYSTEM
2 08/15/2009 00:17:00 /opt/app/oracle/oradata/orcl/sysaux01.dbf SYSAUX
3 08/15/2009 00:52:15 /opt/app/oracle/oradata/orcl/undotbs01.dbf UNDOTBS1
4 08/15/2009 00:17:30 /opt/app/oracle/oradata/orcl/users01.dbf USERS
5 01/10/2011 15:34:17 /opt/app/oracle/oradata/orcl/example01.dbf EXAMPLE
6 04/29/2011 06:54:39 /opt/app/oracle/oradata/orcl/anujtest.dbf ANUJTEST
7 05/12/2011 08:30:08 /opt/app/oracle/oradata/orcl/tsapexf01.dbf TSAPEXF
8 05/12/2011 08:31:48 /opt/app/oracle/oradata/orcl/tsapexu01.dbf TSAPEXU
9 06/28/2011 11:56:10 /opt/app/oracle/oradata/orcl/test.dbf TEST
10 07/04/2011 12:07:49 /opt/app/oracle/oradata/orcl/rman.dbf RMAN
Search This Blog
Total Pageviews
Monday, 12 September 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment