Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sequence verification

user515689Apr 10 2007 — edited Apr 11 2007
Hi,

I've perused the forums for the last half hour and haven't found exactly what I am looking for.

I was looking to select * from user_source where type = 'sequence' to see what all sequences I have in my account without selecting every single thing.
Is there a command for that?

Further, my sequence in my development environment -- after having topped out at #2481, started repeating to 1. As in #1.

So a quick glimpse in the DB table reveals two records with the primary ID as #1 in both tables that receive inserts simultaneously.

Any idea why that would have happened? Why it would start repeating indiscriminantly like that? That befuddles me a bit.
But anyone that can enlighten me on this, I welcome the feedback.

Or instruct me how I need to go about changing this!

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2007
Added on Apr 10 2007
10 comments
1,022 views