Name: | OFFR_U2 |
Table: | OFFR |
Type: | NORMAL |
Unique: | UNIQUE |
Tablespace: | TOOLS |
Status: | VALID |
Descend: | ASC |
Table owner: | RMAN |
Temporary: | No |
Join Index: | No |
Initial extent size: | 65536 |
Secondary extent size: | |
Min extents: | 1 |
Max extents: | 2147483645 |
Percent encrease: | |
Distinct keys: |
Name | Length | Descend | |
|
DBINC_KEY | 22 | ASC |
|
FILE# | 22 | ASC |
|
CREATE_SCN | 22 | ASC |
|
OFFLINE_SCN | 22 | ASC |
|
CF_CREATE_TIME | 7 | ASC |
CREATE UNIQUE INDEX "RMAN"."OFFR_U2" ON "RMAN"."OFFR" ("DBINC_KEY", "FILE#", "CREATE_SCN", "OFFLINE_SCN", "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