[Home] [Help] [Dependency Information]
Object Name: | GV_$BACKUP_PIECE |
---|---|
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 | |||
PIECE# | NUMBER | |||
COPY# | NUMBER | |||
DEVICE_TYPE | VARCHAR2 | (17) | ||
HANDLE | VARCHAR2 | (513) | ||
COMMENTS | VARCHAR2 | (64) | ||
MEDIA | VARCHAR2 | (65) | ||
MEDIA_POOL | NUMBER | |||
CONCUR | VARCHAR2 | (3) | ||
TAG | VARCHAR2 | (32) | ||
STATUS | VARCHAR2 | (1) | ||
DELETED | VARCHAR2 | (3) | ||
START_TIME | DATE | |||
COMPLETION_TIME | DATE | |||
ELAPSED_SECONDS | NUMBER | |||
BYTES | NUMBER | |||
IS_RECOVERY_DEST_FILE | VARCHAR2 | (3) | ||
RMAN_STATUS_RECID | NUMBER | |||
RMAN_STATUS_STAMP | NUMBER | |||
COMPRESSED | VARCHAR2 | (3) | ||
BACKED_BY_VSS | VARCHAR2 | (3) | ||
ENCRYPTED | VARCHAR2 | (3) | ||
BACKED_BY_OSB | VARCHAR2 | (3) | ||
FOR_XTTS | VARCHAR2 | (3) | ||
SAME_ENDIAN | VARCHAR2 | (3) | ||
CON_ID | NUMBER | |||
GUID | RAW | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, RECID
, STAMP
, SET_STAMP
, SET_COUNT
, PIECE#
, COPY#
, DEVICE_TYPE
, HANDLE
, COMMENTS
, MEDIA
, MEDIA_POOL
, CONCUR
, TAG
, STATUS
, DELETED
, START_TIME
, COMPLETION_TIME
, ELAPSED_SECONDS
, BYTES
, IS_RECOVERY_DEST_FILE
, RMAN_STATUS_RECID
, RMAN_STATUS_STAMP
, COMPRESSED
, BACKED_BY_VSS
, ENCRYPTED
, BACKED_BY_OSB
, FOR_XTTS
, SAME_ENDIAN
, CON_ID
, GUID
FROM SYS.GV_$BACKUP_PIECE;
|
|
|