col name format a50
col UNRECOVERABLE_CHANGE# format 999999999999999999999
col dt1 format a30
set lines 120 pages 200
SELECT NAME, UNRECOVERABLE_CHANGE#, TO_CHAR (UNRECOVERABLE_TIME,’DD-MON-YYYY HH:MI:SS’) dt1
FROM V$DATAFILE
WHERE UNRECOVERABLE_CHANGE# != 0;