Properties

Name: BS 
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
  BS_KEY  NUMBER             
  DB_KEY  NUMBER             
  BS_RECID  NUMBER             
  BS_STAMP  NUMBER             
  SET_STAMP  NUMBER             
  SET_COUNT  NUMBER             
  BCK_TYPE  VARCHAR2         
  INCR_LEVEL  NUMBER             
  PIECES  NUMBER             
  START_TIME  DATE           
  COMPLETION_TIME  DATE           
  STATUS  VARCHAR2         
  CONTROLFILE_INCLUDED  VARCHAR2         
  INPUT_FILE_SCAN_ONLY  VARCHAR2         
  KEEP_OPTIONS  NUMBER             
  KEEP_UNTIL  DATE           
Total: 16 column(s)

Indexes

Name Type Unique
  BS_P  NORMAL  UNIQUE 
  BS_U2  NORMAL  UNIQUE 
Total: 2 index(s)

Constraints

Name Type Status Delete rule Defferable Deffered
  BS_C_BCK_TYPE  Not NULL  Enabled    Not Deferrable  Immediate 
  BS_C_CONTROLFILE_INCLUDED  Not NULL  Enabled    Not Deferrable  Immediate 
  BS_C_INCR_LEVEL  Not NULL  Enabled    Not Deferrable  Immediate 
  BS_F1  Referential Integrity  Enabled  Cascade  Not Deferrable  Immediate 
  BS_P  Primary Key  Enabled    Not Deferrable  Immediate 
  BS_U2  Unique Key  Enabled    Not Deferrable  Immediate 
  SYS_C002802  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002803  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002804  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002805  Check  Enabled    Not Deferrable  Immediate 
  SYS_C002806  Check  Enabled    Not Deferrable  Immediate 
Total: 11 constraints

Referenced tables

Name Owner Constraint DELETE_RULE
  BCF  RMAN  BCF_F1  CASCADE 
  BDF  RMAN  BDF_F1  CASCADE 
  BP  RMAN  BP_F1  CASCADE 
  BRL  RMAN  BRL_F1  CASCADE 
  BSF  RMAN  BSF_F1  CASCADE 
Total: 5 referenced table(s)

Table References

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

Table used by

Owner Name Type Level
RMAN  RC_BACKUP_SET  VIEW 
RMAN  RC_BACKUP_PIECE  VIEW 
RMAN  RC_BACKUP_DATAFILE  VIEW 
RMAN  RC_BACKUP_CONTROLFILE  VIEW 
RMAN  RC_BACKUP_SPFILE  VIEW 
RMAN  RC_BACKUP_REDOLOG  VIEW 
RMAN  RC_BACKUP_CORRUPTION  VIEW 
RMAN  DBMS_RCVCAT  PACKAGE BODY 
RMAN  DBMS_RCVMAN  PACKAGE BODY 
Total: 9 used by reference(s)

DDL


  CREATE TABLE "RMAN"."BS"
   (    "BS_KEY" NUMBER NOT NULL ENABLE,
    "DB_KEY" NUMBER NOT NULL ENABLE,
    "BS_RECID" NUMBER,
    "BS_STAMP" NUMBER,
    "SET_STAMP" NUMBER NOT NULL ENABLE,
    "SET_COUNT" NUMBER NOT NULL ENABLE,
    "BCK_TYPE" VARCHAR2(1),
    "INCR_LEVEL" NUMBER,
    "PIECES" NUMBER NOT NULL ENABLE,
    "START_TIME" DATE,
    "COMPLETION_TIME" DATE,
    "STATUS" VARCHAR2(1),
    "CONTROLFILE_INCLUDED" VARCHAR2(7),
    "INPUT_FILE_SCAN_ONLY" VARCHAR2(3),
    "KEEP_OPTIONS" NUMBER,
    "KEEP_UNTIL" DATE,
     CONSTRAINT "BS_C_BCK_TYPE" CHECK (bck_type in ('D','I','L')) ENABLE,
     CONSTRAINT "BS_C_INCR_LEVEL" CHECK (incr_level in (0,1,2,3,4)) ENABLE,
     CONSTRAINT "BS_C_CONTROLFILE_INCLUDED" CHECK (controlfile_included in
                                            ('NONE','BACKUP','STANDBY')) ENABLE,
     CONSTRAINT "BS_P" PRIMARY KEY ("BS_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 "BS_U2" UNIQUE ("DB_KEY", "SET_STAMP", "SET_COUNT")
  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 "BS_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