View: RC_COPY_CORRUPTION

Properties

Name: | RC_COPY_CORRUPTION
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
| DBINC_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| DB_NAME | VARCHAR2 | 8 |  |  |  | N |  |  | NO | NO | NO
| RECID | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| STAMP | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| CDF_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| COPY_RECID | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| COPY_STAMP | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| FILE# | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| CREATION_CHANGE# | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BLOCK# | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| BLOCKS | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| CORRUPTION_CHANGE# | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| MARKED_CORRUPT | VARCHAR2 | 3 |  |  |  | Y |  |  | NO | NO | NO
| CORRUPTION_TYPE | VARCHAR2 | 9 |  |  |  | Y |  |  | YES | YES | YES

Total: 15 column(s)

Used by

Owner | Name | Type | Level
RMAN | RC_DATABASE_BLOCK_CORRUPTION | VIEW | 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_COPY_CORRUPTION" ("DB_KEY", "DBINC_KEY", "DB_NAME", "RECID", "STAMP", "CDF_KEY", "COPY_RECID", "COPY_STAMP", "FILE#", "CREATION_CHANGE#", "BLOCK#", "BLOCKS", "CORRUPTION_CHANGE#", "MARKED_CORRUPT", "CORRUPTION_TYPE") AS
select dbinc.db_key,
dbinc.dbinc_key,
dbinc.db_name,
ccb.ccb_recid recid,
ccb.ccb_stamp stamp,
cdf.cdf_key,
cdf.cdf_recid copy_recid,
cdf.cdf_stamp copy_stamp,
cdf.file#,
cdf.create_scn creation_change#,
ccb.block#,
ccb.blocks,
ccb.corrupt_scn corruption_change#,
decode(ccb.marked_corrupt,'N', 'NO', 'Y', 'YES', '?') marked_corrupt,
ccb.corruption_type
from dbinc, cdf, ccb
where dbinc.dbinc_key = cdf.dbinc_key
and cdf.cdf_key = ccb.cdf_key
and cdf.status = 'A'

See Also

List of views