Upgrade path from 9.0 to 9.1

Sorry guys,

Only had 2 hours of sleep last night due to my new born son.

I'm just confirming what is said above. You can stay with Oracle 10G which is set at 8K block size. You can always test/move to Oracle 11G with 16K block size and a better performance which is always depending system resources of RAM and CPU.

If you are rehosting a Windchill 9.0 application to point to an Oracle 11G database after an import, you need to add these lines to the Windchill 9.0 site.xconf:

<property name="wt.generation.sql.tinyBlobSize" overridable="true"&lt;br"/> targetFile="codebase/user.properties"
value="32k"/>
<property name="wt.generation.sql.smallBlobSize" overridable="true"&lt;br"/> targetFile="codebase/user.properties"

In the command line run the following:

xconfmangager -p

$WT_HOME/bin/JavaGen.shregistry false false true false false

this will reset all your SQLs to increment to 32K ratherthan8K which is less than the 16K for Oracle 11G. Plus, after an import all your data is now contiguous.

Then you are good.
value="32k"/>