Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE PartitionedTable
- (
- id number,
- PartitionKey number,
- created date
- )
- PARTITION BY LIST (PartitionKey) AUTOMATIC
- SUBPARTITION BY RANGE (created) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
- ( PARTITION p_PartitionKey VALUES (1)
- ( SUBPARTITION p_created VALUES LESS THAN (TO_DATE('01-JAN-2000','dd-MON-yyyy'))
- )
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement