Last added datafile in Oracle

Below query will give you the last added datafile in oracle.

This will be useful to check whenever you have datafile related issues.

DBA_HIST_DATAFILE is the view stores information of datafiles.

select a.FILE#,a.FILENAME,a.TSNAME,b.creation_time from DBA_HIST_DATAFILE a,V$datafile b where  a.FILE#=b.FILE# order by b.creation_time;

  • June 30, 2019 | 24 views
  • Comments