Constraint: OFFR_U2 on table OFFR

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]