Re: HELP? Database Sequences Stopped Incrementing

From: Frédéric Trébuchet <frederic.trebuchet_at_sncf.fr>
Date: 1997/11/19
Message-ID: <01bcf506$7507b6e0$be02a994@mimp46>#1/1

Hmmm... I think your DUAL table is empty. It must contain 1 and only 1 line.

TRF Doug Halke <modelworks_at_kellnet.com> a écrit dans l'article <3472FDE1.160D_at_kellnet.com>...
> Hello,
>
> This is a good one. All of our production database sequences suddenly
> stopped incrementing. When we run a SELECT xxxx.nextval from DUAL; on
> any of them, we get a "no rows returned" message. These same sequences
> have no problems in the test instance which is the same 7.1 release on
> the same physical hardware platform. We tried deleting and readding one
> of the sequences and even created a new test sequence to no avail.
>
> So far, Oracle Support has said, "Hmmm..." and has been slow in
> responding back so I thought that I'd try out here.
>
> Anybody have any suggestions?
>
> Doug
>
Received on Wed Nov 19 1997 - 00:00:00 CST