Index: CKP_U1 on table CKP
Index: CKP_U1 on table CKP
| Name: | CKP_U1 |
| Table: | CKP |
| 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 |
|
|
CKP_SCN | 22 | ASC |
|
|
CKP_TYPE | 7 | ASC |
|
|
CKP_CF_SEQ | 22 | ASC |
|
|
CF_CREATE_TIME | 7 | ASC |
CREATE UNIQUE INDEX "RMAN"."CKP_U1" ON "RMAN"."CKP" ("DBINC_KEY", "CKP_SCN", "CKP_TYPE", "CKP_CF_SEQ", "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