I got ” ORA-02289: sequence does not exist ” error in Oracle database.
ORA-02289: sequence does not exist
Details of error are as follows.
ORA-02289: 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.
sequence does not exist
This ORA-02289 errors are related with the specified sequence does not exist, or the user does not have the required
privilege to perform this operation.
Make sure the sequence name is correct, and that you have the right to perform the desired operation on this sequence.
If the related sequence exists on database, then use it ( with its owner ) as follows.
select <owner>.<SEQUNCE_name>.nextval from dual;
Or give Sequence priviliges as follows.
GRANT CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE, SELECT ANY SEQUENCE TO USERNAME;
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )