Name: | ORL_I_1 |
Table: | ORL |
Type: | NORMAL |
Unique: | NONUNIQUE |
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 |
|
THREAD# | 22 | ASC |
|
GROUP# | 22 | ASC |
CREATE INDEX "RMAN"."ORL_I_1" ON "RMAN"."ORL" ("DBINC_KEY", "THREAD#", "GROUP#")
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