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              NO  NO  NO 
  DBINC_KEY  NUMBER              NO  NO  NO 
  DB_NAME  VARCHAR2            NO  NO  NO 
  RECID  NUMBER              YES  YES  YES 
  STAMP  NUMBER              YES  YES  YES 
  CDF_KEY  NUMBER              NO  NO  NO 
  COPY_RECID  NUMBER              NO  NO  NO 
  COPY_STAMP  NUMBER              NO  NO  NO 
  FILE#  NUMBER              NO  NO  NO 
  CREATION_CHANGE#  NUMBER              NO  NO  NO 
  BLOCK#  NUMBER              YES  YES  YES 
  BLOCKS  NUMBER              YES  YES  YES 
  CORRUPTION_CHANGE#  NUMBER              YES  YES  YES 
  MARKED_CORRUPT  VARCHAR2            NO  NO  NO 
  CORRUPTION_TYPE  VARCHAR2            YES  YES  YES 
Total: 15 column(s)

Used by

Owner Name Type Level
RMAN  RC_DATABASE_BLOCK_CORRUPTION  VIEW 
Total: 1 used by reference(s)

Uses

Owner Name Type Level
OLAPSYS  DBA$OLAP2_DIM_LEVELS  VIEW 
OLAPSYS  DBA$OLAP_DIM_LEVELS  VIEW 
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