python + oracle == <3

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]
Tags: python oracle

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]