[Home] [Help] [Dependency Information]
Object Name: | V_$DATAFILE_HEADER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE# | NUMBER | |||
STATUS | VARCHAR2 | (7) | ||
ERROR | VARCHAR2 | (18) | ||
FORMAT | NUMBER | |||
RECOVER | VARCHAR2 | (3) | ||
FUZZY | VARCHAR2 | (3) | ||
CREATION_CHANGE# | NUMBER | |||
CREATION_TIME | DATE | |||
TABLESPACE_NAME | VARCHAR2 | (30) | ||
TS# | NUMBER | |||
RFILE# | NUMBER | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
CHECKPOINT_CHANGE# | NUMBER | |||
CHECKPOINT_TIME | DATE | |||
CHECKPOINT_COUNT | NUMBER | |||
BYTES | NUMBER | |||
BLOCKS | NUMBER | |||
NAME | VARCHAR2 | (513) | ||
SPACE_HEADER | VARCHAR2 | (40) | ||
LAST_DEALLOC_CHANGE# | VARCHAR2 | (16) | ||
UNDO_OPT_CURRENT_CHANGE# | VARCHAR2 | (40) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT FILE#
, STATUS
, ERROR
, FORMAT
, RECOVER
, FUZZY
, CREATION_CHANGE#
, CREATION_TIME
, TABLESPACE_NAME
, TS#
, RFILE#
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, CHECKPOINT_COUNT
, BYTES
, BLOCKS
, NAME
, SPACE_HEADER
, LAST_DEALLOC_CHANGE#
, UNDO_OPT_CURRENT_CHANGE#
, CON_ID
FROM SYS.V_$DATAFILE_HEADER;
|
|
|