If you have Oracle8i at your disposal, then use it. If you're looking to purchase a DBMS, then you have to weigh cost vs. benefits. Personally I would go with Oracle 8i if you need transaction support.
You should also check out PostgreSQL (http://www.postgresql.org).