Introduction
We will see how to find the last added datafile in oracle
Posted by Arun
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;
Recent Posts