Re: HELP? Database Sequences Stopped Incrementing

This could be caused by the dual table . Perhaps you are missing the single row that is supposed to be in dual;

check if you have a valid sual table by

    select count(*) from dual;

if this should return 1 .
If not create an entry on the dual table.

I hope this helps !

Doug Halke 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

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================