Re: Oracle 8 Bugs

We are currently on 7.3.3.4.1, and find that it is th best version of the 7.3 family. We have been trying to migrate to Oracle 8 for the past four months, but have encountered a few issues (not necessarily Oracle bugs) that have postponed our efforts.

1. tape management software vendors have not yet updated their products to work with RMAN, so incremental backup/recovery is quite limited. Vendors say supported maybe by summer time ...
2. third party OLAP and reporting tool vendors have not updated their products to generate queries conducive to partitioning, so queries against partitioned table can often take longer. Partitioning requires that query supply hard coded value in where clause in order to perform partition elimination.
3. where clause with long IN clauses against columns having bitmap indexes cause dedicated server process to core dump. Switching to B-tree indexes corrects problem at cost of much more space and time to create.

These 3 issues alone make migrating our data warehouse precarious at best ...

Bert Scalzo
EDS Rosemary Fleming wrote in message <6bgjmb$t0m$1_at_newsmaster.pathcom.com>...
>What bugs have people encountered when using Oracle 8? Currently we have a
 3
>Gig Oracle 7.2 database running on HP-UX in a Replicated environment (2
>servers, soon to be 4 servers). We will be upgrading our Oracle instance
>this summer and are considering going directly to Oracle 8 rather than
 going
>to Oracle 7.3. However, we want to find out what bugs have been reported in
>Oracle 8 before making a decision. In particular, are there any bugs with
>the Advanced Replication feature? How stable is Oracle 8? Do you recommend
>moving to Oracle 8 for small database or would we be better off going to
>Oracle 7.3 and migrate to Oracle 8 in a years' time?
>
>Thank you for any comments you may have.
>
> Rosemary Fleming
> rosemary_at_cips.ca
>
>
Received on Mon Feb 09 1998 - 00:00:00 CST