1. Take export file
2. Backup
3. remove oracle9i - but leave DOUGLAS\NETSHARE in place
4. Install 10 (ORACLE XE) take defaults
5. In directory SCRIPTS - change CRTDB.SQL by removing paths if needed. Make sure to leave datafile name and the rest alone.
6. Change BUILDUSERS - add line to CREATE USER....
GRANT CREATE VIEW TO SYSDBA
7. After install - there is no visible GUI for TNSNAMES.ORA, so open that file manually. Copy XE block and paste to bottom - call it ORACLE1.
8. Run our scripts as normal - crtdb, buildusers, masterscript