Analytic Workspaces Will Corrupt If 9.2.0.4 Patchset Is Applied
August 29th, 2003 by Mark Rittman
A note on metalink advises that Analytic Workspaces built using Oracle 9i 9.2.0.3 will corrupt if the new 9.2.0.4 patchset is applied. According to the note;
“Please be advised that if you apply the 9.2.0.4.0 patch set to an OLAP 9.2.0.3 instance, previously functioning analytic workspaces may not be accessible after migration. It is our recommendation that OLAP users hold-off with upgrading to 9.2.0.4.0 until OLAP development releases a patch to remedy the situation. This OLAP specific patch will be posted to MetaLink ASAP.
The problem is in the 64-bit Btree code, and it manifests itself as a SegV when trying to access any composite dimension in an AW created in any previous version.”
The recommended solution is to export any Analytic Workspaces (using the OLAP DML command ‘EXPORT ALL TO EIF FILE xxxx’), apply the patch, recreate the Analytic Workspace, then bring the data back in from the export file.
