Oracle11g SDE 10.0.0 to SP5 upgrade - spx_util problem - st_partition_index missing

[SzymonPiskula]

Hi,
I've been upgrading my Oracle 11g SDE 10.0.0 directly to SP5 via ArcCatalog 10.0 SP5 using Upgrade Geodatabase gp tool. The upgrade has failed and after investigation it looks like the root of the problem lies in spx_uti package which can not compile. Namely some of its procedures expect 'st_partition_index' table, but that does not exist in my SDE. I can not see this in my original 10.0 database so i am wondering where should this table come from? Is it missing in SP5 when performing direct update from 10.0.0 ?
Or should it be present already in 10.0.0 ?

[VinceAngelo]

You really ought to contact Tech Support for an upgrade failure issue --
They're the only folks that have reachback to the development team to
untangle nasty knots.

- V

[SzymonPiskula]

After digging around i've found that my tablespace for SDE schema run out of space as autoincrement was set to OFF. After setting it to ON it all worked. Because of the above upgrade script could not create the missing table st_partition_index....