Properties

Name: OFFR_U2 
Table: OFFR 
Type: Unique Key 
Status: Enabled 
Delete rule:  
Defferable: Not Deferrable 
Deffered: Immediate 
R Owner:  
R Constraint:  

Columns

Name
  DBINC_KEY 
  FILE# 
  CREATE_SCN 
  OFFLINE_SCN 
  CF_CREATE_TIME 
Total: 5 column(s)

DDL


  ALTER TABLE "RMAN"."OFFR" ADD CONSTRAINT "OFFR_U2" UNIQUE ("DBINC_KEY", "FILE#", "CREATE_SCN", "OFFLINE_SCN", "CF_CREATE_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

See Also

List of constraints
Table [OFFR]