I recently had a bit of a problem with an Oracle DATE value. En route to finding out more about it, HJR linked to an earlier article he wrote. Very fun stuff.
Partition Exchange for fun and profit
So I was apprised of some goings-on wherein our data warehouse tables were going to (finally) be moving from separate monthly tables (e.g. FOO_200607, FOO_200608, FOO_200609) to a single table with range partitions on the year and month fields and local indexes.The developers were going to just do direct insert... [Read More]