First off, Oracle 8i is no longer supported by Oracle. Are you sure you want to use this version, rather than the newer (and still supported) 9i or the current 10g?
That aside, all you need is your JDBC driver and a JDK. The driver for Oracle is in classes12.zip if I remember right. Your oracle documentation will tell you exactly though; I think there should be a version of "JDBC Developer's Guide and Reference" for Oracle 8i.
You might also find it helpfuil to look though our JDBC FAQs. [ December 11, 2006: Message edited by: Paul Sturrock ]