Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$DATAFILE

Object Details
Object Name: V_$DATAFILE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE# NUMBER

CREATION_CHANGE# NUMBER

CREATION_TIME DATE

TS# NUMBER

RFILE# NUMBER

STATUS VARCHAR2 (7)
ENABLED VARCHAR2 (10)
CHECKPOINT_CHANGE# NUMBER

CHECKPOINT_TIME DATE

UNRECOVERABLE_CHANGE# NUMBER

UNRECOVERABLE_TIME DATE

LAST_CHANGE# NUMBER

LAST_TIME DATE

OFFLINE_CHANGE# NUMBER

ONLINE_CHANGE# NUMBER

ONLINE_TIME DATE

BYTES NUMBER

BLOCKS NUMBER

CREATE_BYTES NUMBER

BLOCK_SIZE NUMBER

NAME VARCHAR2 (513)
PLUGGED_IN NUMBER

BLOCK1_OFFSET NUMBER

AUX_NAME VARCHAR2 (513)
FIRST_NONLOGGED_SCN NUMBER

FIRST_NONLOGGED_TIME DATE

FOREIGN_DBID NUMBER

FOREIGN_CREATION_CHANGE# NUMBER

FOREIGN_CREATION_TIME DATE

PLUGGED_READONLY VARCHAR2 (3)
PLUGIN_CHANGE# NUMBER

PLUGIN_RESETLOGS_CHANGE# NUMBER

PLUGIN_RESETLOGS_TIME DATE

CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE#
,      CREATION_CHANGE#
,      CREATION_TIME
,      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
,      BLOCK_SIZE
,      NAME
,      PLUGGED_IN
,      BLOCK1_OFFSET
,      AUX_NAME
,      FIRST_NONLOGGED_SCN
,      FIRST_NONLOGGED_TIME
,      FOREIGN_DBID
,      FOREIGN_CREATION_CHANGE#
,      FOREIGN_CREATION_TIME
,      PLUGGED_READONLY
,      PLUGIN_CHANGE#
,      PLUGIN_RESETLOGS_CHANGE#
,      PLUGIN_RESETLOGS_TIME
,      CON_ID
FROM SYS.V_$DATAFILE;

Dependencies

[top of page]

SYS.V_$DATAFILE references the following:

SYS.V_$DATAFILE is referenced by following:

SchemaPUBLIC
SynonymV$DATAFILE