Properties

Name: CKP_U1 
Type: NORMAL 
Unique: UNIQUE 
Tablespace: TOOLS 
Status: VALID 
Descend: ASC 
Table owner: RMAN 
Table name: CKP 
Temporary: No 
Join Index: No 
Initial extent size: 65536 
Secondary extent size:  
Min extents:
Max extents: 2147483645 
Percent encrease:  
Distinct keys:  
Minimum free %: 10 

Index Columns

Name Length Descend
  DBINC_KEY  22  ASC 
  CKP_SCN  22  ASC 
  CKP_TYPE  ASC 
  CKP_CF_SEQ  22  ASC 
  CF_CREATE_TIME  ASC 
Total: 5 column(s)

DDL


  CREATE UNIQUE INDEX "RMAN"."CKP_U1" ON "RMAN"."CKP" ("DBINC_KEY", "CKP_SCN", "CKP_TYPE", "CKP_CF_SEQ", "CF_CREATE_TIME")
  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"

See Also

List of indexes