Index: CONF_P1 on table CONF

Properties

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

Index Columns

| Name | Length | Descend
| CONF# | 22 | ASC
| DB_KEY | 22 | ASC

Total: 2 column(s)

DDL

CREATE UNIQUE INDEX "RMAN"."CONF_P1" ON "RMAN"."CONF" ("CONF#", "DB_KEY")
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