Solved

ORA-02289: sequence does not exist

Posted on 2011-02-24
5
5,407 Views
Last Modified: 2012-05-11
I've inherited another developer's code and this query:

select id_seq.nextval from dual

Is causing this error:

ORA-02289: sequence does not exist
02289. 00000 -  "sequence does not exist"
*Cause:    The specified sequence does not exist, or the user does
           not have the required privilege to perform this operation.
*Action:   Make sure the sequence name is correct, and that you have
           the right to perform the desired operation on this sequence.
Error at Line: 1 Column: 7

I'm pretty sure the user has the required privileges to run this query. How can I fix this?

Thanks.
0
Comment
Question by:greddin
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 34971216
3 possibilities

the sequence really does not exist   - check dba_sequences
the user you are using doesn't have privileges   -check dba_tab_privs
a synonym pointing to the sequence doesn't exist  - check dba_synonyms
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 34971249
it must be at least 1 of those 3.

When looking for existence, check for misspellings including possible case sensitivity.

For example did somebody create the sequence as "id_seq"  instead of id_seq?  
0
 

Author Comment

by:greddin
ID: 34971687
Thanks, do I need to use a system user to access and view these dba_sequences, dba_tab_privs, and dba_synonyms tables?

0
 
LVL 74

Expert Comment

by:sdstuber
ID: 34971801
you will need to have privileges to read those,  doesn't necessarily mean SYSTEM or other DBA users though.


you can try using the "ALL_" versions instead of "DBA_" versions of the views, but, those are based on permissions.  So, if you don't have permission to read the object then you won't see them in the ALL_ views either, thus giving a false-negative.

If you don't have permission yourself, ask have to ask your DBA or another privileged user to do it for you.
0
 

Author Closing Comment

by:greddin
ID: 34972926
The sequence didn't exist on this database yet. DBA migrated them over now and all is good.

Thanks for your help.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question