We are planning to upgrade from wM 8.2 to 9.8. Till now we are using Oracle 11g enterprise edition. Now we want to switch to Oracle 11g Standard edition with 9.8 upgrade.I would like to know whether Oracle 11g standard edition is supported by wM ?
If anyone using the 11g standard edition please let me know your experience like.
What are the main differences between both the editions with respect to wM ?
Any issues faced ?
Performance of the DB ?
All products are compatible with the Oracle Standard Edition apart from MFT(ActiveTransfer).
MFT requires “Materialized view rewrites” in Oracle, and this feature is available in “Oracle Enterprise Edition” but not in “Oracle Standard Edition”.
So I guess you could switch to “Oracle Standard Edition” from “Oracle Enterprise Edition” if you are not using MFT.
Apart from the MFT we didn’t face any issue with other products.