SHARE
TWEET

Untitled

a guest Jun 20th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE PartitionedTable
  2. (
  3.   id              number,
  4.   PartitionKey    number,
  5.   created         date
  6. )
  7. PARTITION BY LIST (PartitionKey) AUTOMATIC
  8. SUBPARTITION BY RANGE (created) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
  9. ( PARTITION p_PartitionKey VALUES (1)
  10.   ( SUBPARTITION p_created VALUES LESS THAN (TO_DATE('01-JAN-2000','dd-MON-yyyy'))
  11.   )
  12. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top