[Home] [Help] [Dependency Information]
Object Name: | GV_$DATAFILE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, 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.GV_$DATAFILE;
|
|
|