| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."VIEWS"
|
|
|
2 |
( "VIEW_ID" NUMBER NOT NULL ENABLE,
|
|
|
3 |
"VIEW_NAME" VARCHAR2(30) NOT NULL ENABLE,
|
|
|
4 |
"OWNER_ID" NUMBER NOT NULL ENABLE,
|
|
|
5 |
"BASE_VIEW" CHAR(1) NOT NULL ENABLE,
|
|
|
6 |
"PUBLIC_READ" CHAR(1) NOT NULL ENABLE
|
|
|
7 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
8 |
STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
9 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
10 |
TABLESPACE "SYSTEM" ;
|