ORA-02289

This was tested on Oracle 11.2. You can create a sequence and select the next value from it like this: 

SQL> create sequence seq1

  2  /

 

Sequence created.

 

SQL> select seq1.nextval from dual

  2  /

 

   NEXTVAL

----------

         1

 

SQL> 

… but if you try to use a sequence which does not exist, you get an ORA-02289: 

SQL> select blah.nextval from dual

  2  /

select blah.nextval from dual

       *

ERROR at line 1:

ORA-02289: sequence does not exist

 

SQL>