I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support database links to 8i.
The plan is to link from Oracle 11g to Oracle 10 XE and then to the 8i and hope that one day I won't have to do this.
I have already found articles noting that installing XE after any other version is not recommended.
Has anyone installed XE and another Oracle version side by side? What order was used and what problems were encountered?
Edit: @George3 some forum posts indicate that you can use JDBC drivers to connect 11g and 8i. Please add some detail and post it as answer.