Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE OWNER_PUBLIC.T_NO_CONNECT_CONTRACTS
- (
- CALL_DATE DATE,
- CONTRACT_ID VARCHAR2(10),
- FLAG_WF VARCHAR2(3 CHAR)
- )
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
- STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE OWNER_PUBLIC
- PARTITION BY RANGE (CALL_DATE) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
- (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
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
- NOCOMPRESS LOGGING
- STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE OWNER_PUBLIC
Add Comment
Please, Sign In to add comment