The 10.1.0.3 patchset for Oracle 10g is now available on
MOSC, patch number
3761843. It's a 448MB download and is available now for MS Windows,
Intel Linux, and a few of the 64-bit Unices. There are two
corresponding OLAP patches; OLAP 10.1.0.3.0A patch (patch number
3769360) which Oracle recommend should be applied to all existing
10.1.0.3 installations - both client and server - and a 10.1.0.3B
patch, due out at the end of September, along with version two of the
Analytic Workspace Manager.
The 10.1.0.3A patch introduces a couple of items of new
functionality to Oracle OLAP:
- The existing 10.1.0.1 AWM is upgraded to AWM 10.1.0.3.0A, with
users no longer being required to manually enable the analytic
workspace for query by the OLAP API. Dynamic enablement
automatically creates compatible SQL views over the analytic
workspace even if you change the logical model.
- AWM 10.1.0.3A uses the new
feature for query access, with the forthcoming AWM2 switching over
completely to AWXML for defining and loading AW objects.
Although the 10.1.0.3A patch looks interesting, the major change
for 10g OLAP is coming with the 10.1.0.3B patch, which introduces all
the features outlined in
Mike Ault's 10g
OLAP article and
comments earlier in the year on the OTN OLAP Forum. Oracle OLAP
10.1.0.3B, through it's use of AWXML and AWM2, will allow analytic
workspaces to be created directly from Oracle relational tables, or
flat files using the external tables feature, without the intermediate
step of creating a CWM1-compliant ROLAP cube. In addition, AWM2 will
support new features that have been introduced with 10g OLAP,
including multi-writer support, partitioning and compression, and will
have a big emphasis on users who are 'data dabblers', making it easier
to create and populate analytic workspaces.
The 10.1.0.3B patch, and AWM2, are scheduled to be made available
around 30th September.
As all of this will make the current 10g OLAP documentation out of
OLAP DML Guide is being be re-edited and should be available
within a week. The
OLAP Reference and
App Developer's Guide are being overhauled for 10.1.0.3.0A and
will be available by the end of the month. Then again for 10.1.0.3.0B,
the App Developer's Guide will be updated.
Thanks to Anthony Waite for
making the information available on the OTN OLAP Forum.
UPDATE: Looks like the Windows and Linux versions of the
10.1.0.3 patch have been removed from MOSC, and the OLAP patch
requires a password to download. More news when we work out what's
UPDATE: MOSC Note 281209.1. explains why the patch was
pulled. Apparently it's a problem with CLOBs and NCLOBs on
little-endian (i.e. Windows + Intel Linux) machines. New patch to be
issued soon. Doesn't look as if there'll be problems if you've
installed the old version, unless you're in certain double-byte
territories, and you use CLOBs and NCLOBs, although it'll be best to
re-download the patch when it's available, and install that instead,
if you've not already moved to 10.1.0.3.
UPDATE: The 10.1.0.3 patch is up again on MOSC, and
available to download. Note however that you'll need a password from
Oracle Support to download the 10.1.0.3A OLAP Patch.