Rittman Mead - Delivered Intelligence

I was with a client the other week and was asked to look at a particular SQL statement that kept failing due to lack of TEMP space. It looked something like this (names changed to protect the innocent, etc.) CREATE TABLE lookup_table AS SELECT destn, studref, min(pi) pi fROM ( SELECT pct1.DES as container_type ,pc1.ID [...]

Abhinav Argawal reports in his latest blog posting that Oracle Business Intelligence 10g Phase 2 should be available for download within a few days. The big new thing with Phase 2 is the inclusion of Oracle Reports Services in the BI tier, plus if your a Forms user this will now be present in the [...]

In a recent post, David Aldridge discussed an approach for efficiently rebuilding a table so that partition key migrated from one column to another. This is a somewhat specialised operation and one that most people need not consider (well not unless you do data warehousing and need to revise a partitioning scheme for performance reasons) [...]

I’ve somewhat disappeared off the blogosphere over the last couple of months, with updates to this site pretty few and far between. In fact I’ve actually been busier than ever and doing a lot of research and writing on Oracle BI&W, plus there’s been quite a few developments work-wise that I can’t really go into [...]

Apologies for the lack of updates to the blog recently. I’ve got quite a few things going on with work at the moment which are taking up my time, and I’m also putting the finishing touches to an Oracle OLAP performance tuning paper which will be published on DBAZine later in September. Rest assured, once [...]