Re: DB Broken

Oracle does not maintain any pointers. If sql-queries are correct the database is correct.
Off-topic side note: some people may not appreciate the reference to Hitler. Personally I don't like it.
I know you are joking, but maybe you better compare Bill to Dagobert Duck.

Regards,
Sybrand Bakker, Oracle DBA

<jweisen_at_my-deja.com> wrote in message news:8bgf4q$bpg$1_at_nnrp1.deja.com...
> First, I'd like to say I think it's the application, but I have to ask.
>
> Our A/R system is running on Oracle 7.3.4 for OpenVMS on a DEC Alpha.
> Anyway, the Alpha appears to have a bad CPU, and this past Tuesday it
> rebooted itself. Big Q had a new CPU on order, but both Oracle DBS were
> open at the time.
>
> Things started getting weird on Wed - the app is a graphical screen
> scraper with COBOL driven batch programs behind the scenes. The table
> structures are a mess, was a flat file crammed into Oracle. All
> dependancies are maintained in code.
>
> So starting Wed, people were getting kicked out because "A Serious DB
> Error was encountered". So we dug through the source (we own it), and
> this app does consistency checking at run time.
>
> We wanted to make sure everything was ok, so we exp Production and imp
> into test. The reimp went fine, so it seems some records removed Monday
> caused the prob. We were able to reinsert the records and fix that
> problem (reindexing the table in question of course).
>
> Anyway, at this point I remove the blame from the evil A/R system. Now,
> when a user does a lookup for "ma" for example, they go down to the
> bottom, and then when they go up after reaching the last "ma" they get
> the "s"s.
>
> So what I'm wonder is, does Oracle maintain pointers in the DB that
> could be corrupt? Like I said, I've rebuilt the index for this table and
> it still act's strange. We're looking into a rebuild util for the horrid
> code dependancies, but I want to make sure nothing is wrong in Oracle.
> (SQL queries seem ok).
>
> Thanks,
> John
> --
> **************************************************
> "One World, One Web, One Program" - Microsoft Ad
> "Ein Volk, Ein Reich, Ein Fuhrer" - Adolf Hitler
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 00:00:00 CST