St_Geometry spatial indexes are not creating S###$_IX2

Question

We have  following configuration Oracle on RHEL linux:

**********************ArcSDE install summary:**********************
  ArcSDE 10.1 Oracle_11g (64-bit) Install Location:
  /home/sde/sdeexe101

Service Pack / Patch / Hot Fix Found:

SP-ID: ArcSDE 10.1 Service Pack 1

$ uname -a
Linux xyz 2.6.18-274.el5 #1 SMP Fri Jul 8 17:36:59 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

As described  in "NIM084235 - St_Geometry spatial indexes are not creating S###$_IX2 indexes on the IOT SP_ID column"   for "ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch" (http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1941)  there is missing index on SP_ID column.

Where can be found patch for Oracle ?

regards 
Matjaz

MarcoBoeringa · Answer

I tried the patch and it did not have any effect on my Oracle installation.
It's for PostGIS?

Looking at the installed files, even though PostGreSQL is specifically mentioned in the title of the patch, this patch also seems relevant for Oracle, as files for the other DBMSs are installed as well. Fixes for the other DBMS are related to Parcel Editing.

Do mind the caveat though (see the patch link😞

"If you installed the ST_Geometry type in your Oracle or PostgreSQL database, upgrade the type after you install the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch. See the topic specific to your DBMS for instructions: ..."

Anonymous User · Answer

I tried the patch and it did not have any effect on my Oracle installation.
It's for PostGIS?

ForrestJones · Answer

Hi Matjaz,

The fix/patch for this issue is available at the link you sent (http://support.esri.com/en/downloads...66/metaid/1941).

To upgrade/patch your database on linux, just install the windows setup on your client, connect to your linux database using a direct connection and run upgrade.