Guest User

Untitled

a guest
Apr 24th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. CREATE TABLE OWNER_PUBLIC.T_NO_CONNECT_CONTRACTS
  2. (
  3. CALL_DATE DATE,
  4. CONTRACT_ID VARCHAR2(10),
  5. FLAG_WF VARCHAR2(3 CHAR)
  6. )
  7. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  8. STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  9. TABLESPACE OWNER_PUBLIC
  10. PARTITION BY RANGE (CALL_DATE) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
  11. (PARTITION "P0" VALUES LESS THAN (TO_DATE(' 2018-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
  12. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  13. NOCOMPRESS LOGGING
  14. STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  15. TABLESPACE OWNER_PUBLIC
Add Comment
Please, Sign In to add comment