Table: DB

Properties

Name: DB 
Status: VALID 
Tablespace: TOOLS 
Logging: YES 
Partitioned: NO 
Cached: N 
Locking enabled: ENABLED 
IOT type:  
Object type:  
Type owner:  
Type:  
Temporary: N 
Secondary: N 
Nested: NO 
Buffer pool: DEFAULT 
Row movement: DISABLED 
Index Only Table:  
Minimum % of free space: 10 
Minimum % of udes space:  
Initial transactions: 1 
Max transactions: 255 
Initial extent size, bytes: 65536 
Secondary extent size, bytes:  
Min extents: 1 
Max extents: 2147483645 
% increase in extent:  
Process free list:  
Process free list groups:  
Backee up: N 
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: 1 
Instances: 1 
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: 1 
SizeBytes: 65536 
Description:  

Columns

Name Type Length Nchar Length Precision Scale NULL Default Description
  DB_KEY  NUMBER          N     
  DB_ID  NUMBER          N     
  HIGH_CONF_RECID  NUMBER          Y     
  LAST_KCCDIVTS  NUMBER          Y     
  CURR_DBINC_KEY  NUMBER          Y     
Total: 5 column(s)

Indexes

Name Type Unique
  DB_P  NORMAL  UNIQUE 
  DB_U1  NORMAL  UNIQUE 
Total: 2 index(s)

Constraints

Name Type Status Delete rule Defferable Deffered
  DB_F1  Referential Integrity  Enabled  No Action  Not Deferrable  Immediate 
  DB_P  Primary Key  Enabled    Not Deferrable  Immediate 
  DB_U1  Unique Key  Enabled    Not Deferrable  Immediate 
  SYS_C002658  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002659  Check  Enabled    Not Deferrable  Immediate 
Total: 5 constraints

Referenced tables

Name Owner Constraint DELETE_RULE
  BS  RMAN  BS_F1  CASCADE 
  CONF  RMAN  CONF_F1  CASCADE 
  DBINC  RMAN  DBINC_F1  CASCADE 
  SCR  RMAN  SCR_F1  CASCADE 
Total: 4 referenced table(s)

Table References

Name Owner Constraint DELETE_RULE
  DBINC  RMAN  DB_F1   
Total: 1 table reference(s)

Table used by

Owner Name Type Level
RMAN  RC_DATABASE  VIEW  0 
RMAN  RC_DATABASE_INCARNATION  VIEW  0 
RMAN  RC_BACKUP_SET  VIEW  0 
RMAN  RC_BACKUP_PIECE  VIEW  0 
RMAN  RC_BACKUP_SPFILE  VIEW  0 
RMAN  RC_STORED_SCRIPT  VIEW  0 
RMAN  RC_STORED_SCRIPT_LINE  VIEW  0 
RMAN  RC_RMAN_CONFIGURATION  VIEW  0 
RMAN  DBMS_RCVCAT  PACKAGE BODY  0 
RMAN  DBMS_RCVMAN  PACKAGE BODY  0 
Total: 10 used by reference(s)

DDL


  CREATE TABLE "RMAN"."DB"
   (    "DB_KEY" NUMBER NOT NULL ENABLE,
    "DB_ID" NUMBER NOT NULL ENABLE,
    "HIGH_CONF_RECID" NUMBER,
    "LAST_KCCDIVTS" NUMBER,
    "CURR_DBINC_KEY" NUMBER,
     CONSTRAINT "DB_P" PRIMARY KEY ("DB_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 "DB_U1" UNIQUE ("DB_ID")
  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 "DB_F1" FOREIGN KEY ("CURR_DBINC_KEY")
      REFERENCES "RMAN"."DBINC" ("DBINC_KEY") 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