[Home] [Help] [Dependency Information]
Object Name: | V_$BACKUP_DATAFILE_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BTYPE | CHAR | (9) | ||
BTYPE_KEY | NUMBER | |||
SESSION_KEY | NUMBER | |||
SESSION_RECID | NUMBER | |||
SESSION_STAMP | NUMBER | |||
ID1 | NUMBER | |||
ID2 | 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 | |||
MARKED_CORRUPT | NUMBER | |||
FILESIZE | NUMBER | |||
COMPRESSION_RATIO | NUMBER | |||
TS# | NUMBER | |||
TSNAME | VARCHAR2 | (30) | ||
FILESIZE_DISPLAY | VARCHAR2 | (4000) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BTYPE
, BTYPE_KEY
, SESSION_KEY
, SESSION_RECID
, SESSION_STAMP
, ID1
, ID2
, FILE#
, CREATION_CHANGE#
, CREATION_TIME
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, INCREMENTAL_LEVEL
, INCREMENTAL_CHANGE#
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, MARKED_CORRUPT
, FILESIZE
, COMPRESSION_RATIO
, TS#
, TSNAME
, FILESIZE_DISPLAY
, CON_ID
FROM SYS.V_$BACKUP_DATAFILE_DETAILS;
|
|
|