Advertisement
Guest User

skill Table

a guest
Aug 4th, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. CREATE TABLE "HR"."SKILLTABLE"
  2. ( "ID" NUMBER NOT NULL ENABLE,
  3. "SKILL_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,
  4. "SKILL DESCRIPTION" VARCHAR2(100 BYTE) NOT NULL ENABLE,
  5. CONSTRAINT "SKILLTABLE_PK" PRIMARY KEY ("ID"),
  6.  
  7. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  8. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  9. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  10. TABLESPACE "USERS" ENABLE
  11. ) SEGMENT CREATION IMMEDIATE
  12. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  13. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  14. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  15. TABLESPACE "USERS" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement