10g R2 - 10.2.0.1.0 on Linux RHEL4
We have a number of documents in the database stored as BLOBs.
Increasingly we are being asked to provide a method by which a number of
these can be delivered to a user as a ZIP file.

I have an Oracle 9.2 database.
If I use the 9.2 driver java.sql.Time is stored with 1900-01-01 HH:MM.
If I use the 10.2 driver java.sql.Time is stored with 1970-01-01 HH:MM.
Is this a know bug/feature?

I want to remove all the contents of a schema (tables, indexes,
sequences...) in my development box so I can checkout a fresh working
copy of the web site I'm working on and generate all objects from
scratch. The server runs version 9.2.0.1.0 in a separate network machine

We upgraded database from 9i to 10g at the weekend. One of the
processes (whose statement basically consists of an "create table as
select etc") is taking +7hrs and still running instead of the more
usual 30 mins. OK, I would think that this is a statistics/explain-

Today I have another question regarding estimating effectivity of
changes.
Situation: we have a query that accesses four tables, which result in
18 buffer gets per execution and 3 physical reads.  The plan looks

I installed 10.2.0.1 on AIX6
in a directory /logi/ora/1020,
installation is OK
but i saw a /logi/ora/920 created with

Does anyone know if it's possible to perform an export and import of
the SQL Statement Cache in Oracle 8i?
Thanks
Steve.