[Home] [Help] [Dependency Information]
Object Name: | GV_$BACKUP_DATAFILE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
RECID | NUMBER | |||
STAMP | NUMBER | |||
SET_STAMP | NUMBER | |||
SET_COUNT | NUMBER | |||
FILE# | NUMBER | |||
CREATION_CHANGE# | NUMBER | |||
CREATION_TIME | DATE | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
INCREMENTAL_LEVEL | NUMBER | |||
INCREMENTAL_CHANGE# | NUMBER | |||
CHECKPOINT_CHANGE# | NUMBER | |||
CHECKPOINT_TIME | DATE | |||
ABSOLUTE_FUZZY_CHANGE# | NUMBER | |||
MARKED_CORRUPT | NUMBER | |||
MEDIA_CORRUPT | NUMBER | |||
LOGICALLY_CORRUPT | NUMBER | |||
DATAFILE_BLOCKS | NUMBER | |||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
OLDEST_OFFLINE_RANGE | NUMBER | |||
COMPLETION_TIME | DATE | |||
CONTROLFILE_TYPE | VARCHAR2 | (1) | ||
USED_CHANGE_TRACKING | VARCHAR2 | (3) | ||
BLOCKS_READ | NUMBER | |||
USED_OPTIMIZATION | VARCHAR2 | (3) | ||
FOREIGN_DBID | NUMBER | |||
PLUGGED_READONLY | VARCHAR2 | (3) | ||
PLUGIN_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_TIME | DATE | |||
SECTION_SIZE | NUMBER | |||
UNDO_OPTIMIZED | VARCHAR2 | (3) | ||
BLOCKS_SKIPPED_IN_CELL | NUMBER | |||
CON_ID | NUMBER | |||
BACKED_BY_PDB | VARCHAR2 | (3) | ||
GUID | RAW | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, RECID
, STAMP
, SET_STAMP
, SET_COUNT
, FILE#
, CREATION_CHANGE#
, CREATION_TIME
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, INCREMENTAL_LEVEL
, INCREMENTAL_CHANGE#
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, ABSOLUTE_FUZZY_CHANGE#
, MARKED_CORRUPT
, MEDIA_CORRUPT
, LOGICALLY_CORRUPT
, DATAFILE_BLOCKS
, BLOCKS
, BLOCK_SIZE
, OLDEST_OFFLINE_RANGE
, COMPLETION_TIME
, CONTROLFILE_TYPE
, USED_CHANGE_TRACKING
, BLOCKS_READ
, USED_OPTIMIZATION
, FOREIGN_DBID
, PLUGGED_READONLY
, PLUGIN_CHANGE#
, PLUGIN_RESETLOGS_CHANGE#
, PLUGIN_RESETLOGS_TIME
, SECTION_SIZE
, UNDO_OPTIMIZED
, BLOCKS_SKIPPED_IN_CELL
, CON_ID
, BACKED_BY_PDB
, GUID
FROM SYS.GV_$BACKUP_DATAFILE;
|
|
|