| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES"
|
|
|
2 |
( "SESSION_NUM" NUMBER NOT NULL ENABLE,
|
|
|
3 |
"LEVEL_NUM" NUMBER NOT NULL ENABLE,
|
|
|
4 |
"PV_ID" NUMBER NOT NULL ENABLE,
|
|
|
5 |
"PKG_ID" NUMBER NOT NULL ENABLE,
|
|
|
6 |
"V_EXT" VARCHAR2(50),
|
|
|
7 |
"TES_STATE" NUMBER NOT NULL ENABLE
|
|
|
8 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
9 |
STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
10 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
11 |
TABLESPACE "USERS" ;
|