Finally got around to installing the cx_Oracle lib for python. Since my Oracle sandbox at work is only CentOS3 (to be as close to prod RHEL3 as possible), I only have python 2.2, so I needed to build/install from source. Sadly, I didn't realize how trivial this was, but it's... [Read More]
Origins of Days and Oracle's DATE
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]