I came across this post about Oracle partitioning licensing a couple weeks ago (yes I'm catching up with all the blogging). In it, Mathias basically doesn't think that partitioning should be separately licensed at all, and included in ALL versions of Oracle.For those of you who haven't had the pleasure:To... [Read More]
Perils and Pitfalls in Oracle Partitioning: Bind Variables?
Recently one of my developers found some articles by Arup Nanda while researching a query performance problem. The articles were title "Perils and Pitfalls in Partitioning," parts 1 and 2.In particular he was curious about this statement in part 2:While using partitioning, should you use bind variables? This is an... [Read More]
Joining on substrings
Jonathan Lewis shared an example of joining two tables where the joining field on table is comprised of two fields on the other table. The original poster thought he'd need to re-design his table, but Jonathan proved otherwise with the grace and efficiency of a true Englishman.Definitely good to know!... [Read More]
It started with the LOLCATS. Then we had the ORLY thing and the "in ur base" thing. It's all one big conglomeration now, and it has belched forth LOLCODE. I'm told there is a parser/compiler for LOLCODE, but my head hurts just thinking about it.But it does beg the question... [Read More]
CSALTER requires a clean CSSCAN
Following up to my last post, it turns out that CSALTER requires you to have clean data and produce a clean CSSCAN within 7 days prior to running the character set migration script.If the CSSCAN isn't clean, you'll get this:Checking data validility... Exceptional data found in scanner result PL/SQL procedure... [Read More]