Databases Reference
In-Depth Information
Before Merging Partition
PARTITION-1
(EMPTY)
< JAN-11
PARTITION-2
(DATA)
JAN-11 TO
MAR-11
PARTITION-3
(DATA)
APR-11 TO
JUN-11
PARTITION-4
(DATA)
JUL-11 TO
SEP-11
PARTITION-5
(DATA)
OCT-11 TO
DEC-11
PARTITION-6
(EMPTY)
JAN-12 TO
MAR-12
Staging Table
After Merging Partition
PARTITION-1
(EMPTY)
< APR-11
PARTITION-2
(DATA)
APR-11 TO
JUN-11
PARTITION-3
(DATA)
JUL-11 TO
SEP-11
PARTITION-4
(DATA)
OCT-11 TO
DEC-11
PARTITION-5
(EMPTY)
JAN-12 TO
MAR-12
To load new bulk data (for the quarter spanning Jan 12 to Mar 12), we split the last partition
by introducing a new boundary value (which will be 1st, Apr 12) and loading data for the
quarter spanning Jan 12 to Mar 12 to its respective partition. The following figure shows
how partition splitting and switching will occur:
Partition Splitting and Switching
PARTITION-1
(EMPTY)
< APR-11
PARTITION-2
(DATA)
APR-11 TO
JUN-11
PARTITION-3
(DATA)
JUL-11 TO
SEP-11
PARTITION-4
(DATA)
OCT-11 TO
DEC-11
PARTITION-5
(DATA)
JAN-12 TO
MAR-12
PARTITION-6
(EMPTY)
APR-12 TO
JUN-12
Staging Table with
New Data
Search WWH ::
Custom Search