select
  FILE#,                                   -- FILE# NUMBER
  STATUS,                                  -- STATUS VARCHAR2(7)
  ERROR,                                   -- ERROR VARCHAR2(18)
  FORMAT,                                  -- FORMAT NUMBER
  RECOVER,                                 -- RECOVER VARCHAR2(3)
  FUZZY,                                   -- FUZZY VARCHAR2(3)
  CREATION_CHANGE#,                        -- CREATION_CHANGE# NUMBER
  CREATION_TIME,                           -- CREATION_TIME DATE
  TABLESPACE_NAME,                         -- TABLESPACE_NAME VARCHAR2(30)
  TS#,                                     -- TS# NUMBER
  RFILE#,                                  -- RFILE# NUMBER
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  CHECKPOINT_TIME,                         -- CHECKPOINT_TIME DATE
  CHECKPOINT_COUNT,                        -- CHECKPOINT_COUNT NUMBER
  BYTES,                                   -- BYTES NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  NAME,                                    -- NAME VARCHAR2(513)
  SPACE_HEADER,                            -- SPACE_HEADER VARCHAR2(40)
  LAST_DEALLOC_CHANGE#,                    -- LAST_DEALLOC_CHANGE# VARCHAR2(16)
  UNDO_OPT_CURRENT_CHANGE#                 -- UNDO_OPT_CURRENT_CHANGE# VARCHAR2(40)
from
  GV$DATAFILE_HEADER
where
  inst_id = USERENV('Instance')