Q: ORA-02289 error when using SELECT statement on sequence

I'm a new Oracle DB wanna be (just practicing right now), and, out of curiosity, I created a new user who has SELECT permission to my STUDENTS table. I can select all the rows just fine using a SELECT * statement, but when I use this statement:

 select STUDENT_ID.nextval from sys.STUDENTS

I receive the following error:

ERROR at line 1:
ORA-02289: sequence does not exist

What is happening, and how can I correct it?

Thank you,
Scott Received on Tue Aug 27 2002 - 19:01:48 CDT