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 [...]

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 Forms & Reports installation [...]

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)
In [...]

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 now
but are going [...]

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 I’ve [...]