V$TEMPFILE

Data Dictionary View

Columns
   ___________________________
 
   FILE#
   CREATION_CHANGE#
   CREATION_TIME
   TS#
   RFILE#
   STATUS
   ENABLED
   BYTES
   BLOCKS
   CREATE_BYTES
   BLOCK_SIZE
   NAME

Related:

DBA_TEMP_FILES - List of temporary files
V$DATAFILE - List of data files.


© Copyright SS64.com 1999-2014
Some rights reserved