Properties

Name: DBINC 
Status: VALID 
Tablespace: TOOLS 
Logging: YES 
Partitioned: NO 
Cached:
Locking enabled: ENABLED 
IOT type:  
Object type:  
Type owner:  
Type:  
Temporary:
Secondary:
Nested: NO 
Buffer pool: DEFAULT 
Row movement: DISABLED 
Index Only Table:  
Minimum % of free space: 10 
Minimum % of udes space:  
Initial transactions:
Max transactions: 255 
Initial extent size, bytes: 65536 
Secondary extent size, bytes:  
Min extents:
Max extents: 2147483645 
% increase in extent:  
Process free list:  
Process free list groups:  
Backee up:
Rows:  
Used blocks:  
Empty blocks:  
Average free space:  
Chained rows:  
Average row length:  
Average freespace on a freelist:  
Blocks on a freelist:  
Threds per instance:
Instances:
Sample size:  
Last analysed:  
Global statistics: NO 
User statistics: NO 
Duration:  
Skip corrupt blocks: DISABLED 
Monitoring: NO 
Cluster owner:  
Dependencies: DISABLED 
SizeMB: 0.06 
Extents:
SizeBytes: 65536 
Description:  

Columns

Name Type Length Nchar Length Precision Scale NULL Default Description
  DBINC_KEY  NUMBER             
  DB_KEY  NUMBER             
  DB_NAME  VARCHAR2         
  RESET_SCN  NUMBER             
  RESET_TIME  DATE           
  PARENT_DBINC_KEY  NUMBER             
  CF_CREATE_TIME  DATE           
  CKP_SCN  NUMBER          0    
  FULL_CKP_CF_SEQ  NUMBER          0    
  JOB_CKP_CF_SEQ  NUMBER          0    
  HIGH_TS_RECID  NUMBER             
  HIGH_DF_RECID  NUMBER             
  HIGH_RT_RECID  NUMBER             
  HIGH_ORL_RECID  NUMBER             
  HIGH_OFFR_RECID  NUMBER          0    
  HIGH_RLH_RECID  NUMBER          0    
  HIGH_AL_RECID  NUMBER          0    
  HIGH_BS_RECID  NUMBER          0    
  HIGH_BP_RECID  NUMBER          0    
  HIGH_BDF_RECID  NUMBER          0    
  HIGH_CDF_RECID  NUMBER          0    
  HIGH_BRL_RECID  NUMBER          0    
  HIGH_BCB_RECID  NUMBER          0    
  HIGH_CCB_RECID  NUMBER          0    
  HIGH_DO_RECID  NUMBER          0    
  HIGH_PC_RECID  NUMBER          0    
  HIGH_BSF_RECID  NUMBER          0    
Total: 27 column(s)

Indexes

Name Type Unique
  DBINC_P  NORMAL  UNIQUE 
  DBINC_U1  NORMAL  UNIQUE 
Total: 2 index(s)

Constraints

Name Type Status Delete rule Defferable Deffered
  DBINC_F1  Referential Integrity  Enabled  Cascade  Not Deferrable  Immediate 
  DBINC_P  Primary Key  Enabled    Not Deferrable  Immediate 
  DBINC_U1  Unique Key  Enabled    Not Deferrable  Immediate 
  SYS_C002667  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002668  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002669  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002670  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002671  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002672  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002673  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002674  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002675  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002676  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002677  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002678  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002679  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002680  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002681  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002682  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002683  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002684  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002685  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002686  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002687  Check  Enabled    Not Deferrable  Immediate 
Total: 24 constraints

Referenced tables

Name Owner Constraint DELETE_RULE
  AL  RMAN  AL_F1  CASCADE 
  CCF  RMAN  CCF_F1  CASCADE 
  CDF  RMAN  CDF_F1  CASCADE 
  CKP  RMAN  CKP_F1  CASCADE 
  DB  RMAN  DB_F1  NO ACTION 
  OFFR  RMAN  OFFR_F1  CASCADE 
  RLH  RMAN  RLH_F1  CASCADE 
  RR  RMAN  RR_F1  CASCADE 
  RT  RMAN  RT_F1  CASCADE 
  TS  RMAN  TS_F1  CASCADE 
  XCF  RMAN  XCF_F1  CASCADE 
  XDF  RMAN  XDF_F1  CASCADE 
Total: 12 referenced table(s)

Table References

Name Owner Constraint DELETE_RULE
  DB  RMAN  DBINC_F1   
Total: 1 table reference(s)

Table used by

Owner Name Type Level
RMAN  RC_DATABASE  VIEW 
RMAN  RC_DATABASE_INCARNATION  VIEW 
RMAN  RC_RESYNC  VIEW 
RMAN  RC_CHECKPOINT  VIEW 
RMAN  RC_TABLESPACE  VIEW 
RMAN  RC_DATAFILE  VIEW 
RMAN  RC_REDO_THREAD  VIEW 
RMAN  RC_REDO_LOG  VIEW 
RMAN  RC_LOG_HISTORY  VIEW 
RMAN  RC_ARCHIVED_LOG  VIEW 
RMAN  RC_BACKUP_DATAFILE  VIEW 
RMAN  RC_BACKUP_CONTROLFILE  VIEW 
RMAN  RC_DATAFILE_COPY  VIEW 
RMAN  RC_CONTROLFILE_COPY  VIEW 
RMAN  RC_BACKUP_REDOLOG  VIEW 
RMAN  RC_BACKUP_CORRUPTION  VIEW 
RMAN  RC_COPY_CORRUPTION  VIEW 
RMAN  RC_OFFLINE_RANGE  VIEW 
RMAN  RC_STORED_SCRIPT  VIEW 
RMAN  RC_PROXY_DATAFILE  VIEW 
RMAN  RC_PROXY_CONTROLFILE  VIEW 
RMAN  DBMS_RCVCAT  PACKAGE BODY 
RMAN  DBMS_RCVMAN  PACKAGE BODY 
Total: 23 used by reference(s)

DDL


  CREATE TABLE "RMAN"."DBINC"
   (    "DBINC_KEY" NUMBER NOT NULL ENABLE,
    "DB_KEY" NUMBER NOT NULL ENABLE,
    "DB_NAME" VARCHAR2(8) NOT NULL ENABLE,
    "RESET_SCN" NUMBER NOT NULL ENABLE,
    "RESET_TIME" DATE NOT NULL ENABLE,
    "PARENT_DBINC_KEY" NUMBER,
    "CF_CREATE_TIME" DATE,
    "CKP_SCN" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "FULL_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "JOB_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_TS_RECID" NUMBER,
    "HIGH_DF_RECID" NUMBER,
    "HIGH_RT_RECID" NUMBER,
    "HIGH_ORL_RECID" NUMBER,
    "HIGH_OFFR_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_RLH_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_AL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BS_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BP_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_CDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BRL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_CCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_DO_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_PC_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
    "HIGH_BSF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
     CONSTRAINT "DBINC_P" PRIMARY KEY ("DBINC_KEY")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TOOLS"  ENABLE,
     CONSTRAINT "DBINC_U1" UNIQUE ("DB_KEY", "RESET_SCN", "RESET_TIME")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TOOLS"  ENABLE,
     CONSTRAINT "DBINC_F1" FOREIGN KEY ("DB_KEY")
      REFERENCES "RMAN"."DB" ("DB_KEY") ON DELETE CASCADE ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TOOLS"

See Also

List of tables