Oracle XE 11gR2 beta has just been released, some details here and download here. It’s not a great deal of use for sandboxing DWH-specific stuff, given this list of excluded functionality (and this is by no means everything that’s not included):
- Bitmapped index, bitmapped join index, and bitmap plan conversions
- Oracle Partitioning
- Parallel Data Pump Export/Import
- Parallel query/DML
- Parallel Statement Queuing
(source)
However, it’s always interesting to have to hand for trying out other things. And I like playing with new toys :)
On running the installer, I hit this problem:
[…]
Checking for Oracle XE Service instance…: Expected result : OracleXEService should not be installed already. Actual result: OracleServiceXE found on system. Check complete: The overall result of this check is failed.
The previous owner of the machine had installed Oracle XE 10, but I’d removed this:
Or so I thought:
To remove the service entry, use the sc command: [sourcecode] sc delete OracleServiceXE [/sourcecode]
For good measure I did the same for OracleJobSchedulerXE.
After this, installation proceeded as normal.