| 221 |
vnguyen |
1 |
CREATE INDEX "RELEASE_MANAGER"."INX_FILE_NAME" ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" (UPPER("FILE_NAME"))
|
|
|
2 |
PCTFREE 10 INITRANS 2 MAXTRANS 255
|
|
|
3 |
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
4 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
5 |
TABLESPACE "USERS" PARALLEL 1 ;
|
|
|
6 |
|
|
|
7 |
ALTER INDEX "RELEASE_MANAGER"."INX_FILE_NAME" NOPARALLEL;
|
|
|
8 |
|
|
|
9 |
CREATE INDEX "RELEASE_MANAGER"."INX_PC_FILE_NAME" ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" (UPPER("FILE_NAME"))
|
|
|
10 |
PCTFREE 10 INITRANS 2 MAXTRANS 255
|
|
|
11 |
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
12 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
13 |
TABLESPACE "USERS" PARALLEL 1 ;
|
|
|
14 |
|
|
|
15 |
ALTER INDEX "RELEASE_MANAGER"."INX_PC_FILE_NAME" NOPARALLEL;
|
|
|
16 |
|