Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP? Database Sequences Stopped Incrementing
On Wed, 19 Nov 1997 09:55:29 -0500, Doug Halke <modelworks_at_kellnet.com> wrote:
>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
The message would indicate that there are no rows in the dual table.
Try select * from dual; and select * from sys.dual; Check where the dual synonym is pointing and that you do not have a local table called dual.
Sys.dual should contain one row containing 'x' Received on Thu Nov 20 1997 - 00:00:00 CST