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;
Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…
Please follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…
