View: RC_BACKUP_PIECE

Properties

Name: | RC_BACKUP_PIECE
Status: | VALID
Last modify: | 05/12/2002
Created: | 05/12/2002
Description: |

Columns

| Name | Type | Length | Nchar Length | Precision | Scale | NULL | Default | Comment | Updatable | Deletable | Insertable
| DB_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| DB_ID | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BP_KEY | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| RECID | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| STAMP | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| BS_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| SET_STAMP | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| SET_COUNT | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BACKUP_TYPE | VARCHAR2 | 1 |  |  |  | Y |  |  | NO | NO | NO
| INCREMENTAL_LEVEL | NUMBER |  |  |  |  | Y |  |  | NO | NO | NO
| PIECE# | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| COPY# | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| DEVICE_TYPE | VARCHAR2 | 255 |  |  |  | N |  |  | YES | YES | YES
| HANDLE | VARCHAR2 | 1024 |  |  |  | N |  |  | YES | YES | YES
| COMMENTS | VARCHAR2 | 255 |  |  |  | Y |  |  | YES | YES | YES
| MEDIA | VARCHAR2 | 80 |  |  |  | Y |  |  | YES | YES | YES
| MEDIA_POOL | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| CONCUR | VARCHAR2 | 3 |  |  |  | Y |  |  | NO | NO | NO
| TAG | VARCHAR2 | 32 |  |  |  | Y |  |  | YES | YES | YES
| START_TIME | DATE | 7 |  |  |  | N |  |  | YES | YES | YES
| COMPLETION_TIME | DATE | 7 |  |  |  | N |  |  | YES | YES | YES
| ELAPSED_SECONDS | NUMBER |  |  |  |  | Y |  |  | NO | NO | NO
| STATUS | VARCHAR2 | 1 |  |  |  | N |  |  | YES | YES | YES

Total: 23 column(s)

Used by

Owner | Name | Type | Level
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0

Total: 1 used by reference(s)

Uses

Owner | Name | Type | Level
OLAPSYS | DBA$OLAP2_DIM_LEVELS | VIEW | 1
OLAPSYS | DBA$OLAP_DIM_LEVELS | VIEW | 1

Total: 2 use reference(s)

DDL

CREATE OR REPLACE FORCE VIEW "RMAN"."RC_BACKUP_PIECE" ("DB_KEY", "DB_ID", "BP_KEY", "RECID", "STAMP", "BS_KEY", "SET_STAMP", "SET_COUNT", "BACKUP_TYPE", "INCREMENTAL_LEVEL", "PIECE#", "COPY#", "DEVICE_TYPE", "HANDLE", "COMMENTS", "MEDIA", "MEDIA_POOL", "CONCUR", "TAG", "START_TIME", "COMPLETION_TIME", "ELAPSED_SECONDS", "STATUS") AS
select db.db_key,
db.db_id,
bp.bp_key,
bp.bp_recid recid,
bp.bp_stamp stamp,
bs.bs_key,
bs.set_stamp,
bs.set_count,
bs.bck_type backup_type,
bs.incr_level incremental_level,
bp.piece#,
bp.copy#,
bp.device_type,
bp.handle,
bp.comments,
bp.media,
bp.media_pool,
decode(bp.concur, 'N', 'NO', 'Y', 'YES', '?') concur,
bp.tag,
bp.start_time,
bp.completion_time,
((bp.completion_time - bp.start_time) * 86400) elapsed_seconds,
bp.status
from db, bs, bp
where db.db_key = bs.db_key
and bs.bs_key = bp.bs_key

See Also

List of views