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

VIEW: SYS.V_$BACKUP_PIECE_DETAILS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SESSION_KEY NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

BS_KEY NUMBER

BP_KEY 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)
START_TIME DATE

COMPLETION_TIME DATE

ELAPSED_SECONDS NUMBER

DELETED VARCHAR2 (3)
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

PIECES_PER_SET NUMBER

SIZE_BYTES_DISPLAY VARCHAR2 (4000)
Query Text

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


SELECT SESSION_KEY
,      SESSION_RECID
,      SESSION_STAMP
,      BS_KEY
,      BP_KEY
,      RECID
,      STAMP
,      SET_STAMP
,      SET_COUNT
,      PIECE#
,      COPY#
,      DEVICE_TYPE
,      HANDLE
,      COMMENTS
,      MEDIA
,      MEDIA_POOL
,      CONCUR
,      TAG
,      STATUS
,      START_TIME
,      COMPLETION_TIME
,      ELAPSED_SECONDS
,      DELETED
,      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
,      PIECES_PER_SET
,      SIZE_BYTES_DISPLAY
FROM SYS.V_$BACKUP_PIECE_DETAILS;

Dependencies

[top of page]

SYS.V_$BACKUP_PIECE_DETAILS references the following:

SchemaSYS
PL/SQL PackageDBMS_RCVMAN - show dependent code
SYS.V_$BACKUP_PIECE_DETAILS is referenced by following:

SchemaPUBLIC
SynonymV$BACKUP_PIECE_DETAILS