V$DATAFILE

An entry for each datafile.

Columns
   ___________________________
 
   FILE#
   NAME

   TS#
   RFILE#
   STATUS
   ENABLED
   CHECKPOINT_CHANGE#
   CHECKPOINT_TIME
   UNRECOVERABLE_CHANGE#
   UNRECOVERABLE_TIME
   LAST_CHANGE#
   LAST_TIME
   OFFLINE_CHANGE#
   ONLINE_CHANGE#
   ONLINE_TIME
   BYTES
   BLOCKS
   CREATE_BYTES
   CREATION_CHANGE#
   CREATION_TIME
   BLOCK_SIZE
   PLUGGED_IN
   BLOCK1_OFFSET
   AUX_NAME

Example
select name, status from v$datafile

Related:

dba_data_files 
V$COMPATIBILITY 
V$COMPATSEG 
V$COPY_CORRUPTION 
V$DATABASE 
V$DATAFILE_COPY 
V$DATAFILE_HEADER 
V$DBFILE 
V$DBLINK 
V$DB_PIPES 
V$TABLESPACE 
V$TEMPFILE 
V$VERSION


© Copyright SS64.com 1999-2014
Some rights reserved