HELP? Database Sequences Stopped Incrementing

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