Sequence Doesn't Exist Ora-02289

sequence doesn't exist ORA-02289

You will either have to fully qualify your sequence via:

SELECT <owner>.<sequence name>.nextval FROM dual;

Or create a public synonym for it:

CREATE PUBLIC SYNONYM TOT_SEQ for OWNER.TOT_SEQ;
SELECT TOT_SEQ.nexval FROM DUAL;

ORA-02289: sequence does not exist, however sequence is aleady exist in database

A missing sequence that exists may be caused from two reasons:

1) the sequence exists in a different schema that you are connected with

in this case you must reference schema_owner.schema_name

2) the sequence exists in a different schema and you have no privileges to access it

You should first realize in which schema the existing sequence is created.

You can verify it with the following query (substitute the sequence name as required)

select OWNER, OBJECT_NAME SEQUENCE_NAME
from all_objects where object_type = 'SEQUENCE' 
and lower(object_name) = 'id_seq1';

If you see nothing, the sequence either doesn't exists or it exists in a different schema as you are connected with and you have no SELECT priviledge on it.

In case you use a sequence from a different schema than your Hibernate connection user (which is rather a usual case), you must use the schema parameter of the @SequenceGenerator annotation and pass the propper schema owner.

PL/SQL Throwing Error ORA-02289: sequence does not exist (Oracle SQL)

Presumably the DEVICE_LOCKING_SEQ sequence object does not exist.

This would be a standalone object in its own right and not, for example, part of a table. So you should have a CREATE SEQUENCE ... statement

ORA-02289: sequence does not exist oracle

Note that the schema name is specified twice in your SQL; this is causing the error:

INSERT INTO "XXBRIM_SUBHEADER_INTERMEDIA_T" ("ID_PK") VALUES ("XXBRIM.XXBRIM.XXBRIM_HEADER_ID_INCREAMENT".nextval) RETURNING "XXBRIM_SUBHEADER_INTERMEDIA_T"."ID_PK" INTO :ret_0]

I would recommend not specifying the schema name in your column definition, as it seems to be getting added automatically somewhere else along the way.

ID_PK = Column(Integer, Sequence('XXBRIM_header_inter_id_SEQUENCE'))

JPA (Hibernate): ORA-02289 Sequence does not exist, but it does

I found the error: It was my local setup, so nothing useful to tell you, just check your setup.

I was "configuring" my server in files that aren't actually used by the server, and thus showed no effect.

sequence already created but error showing RA-02289: sequence does not exist

You are using wrong seq name test_req while correct name is test_seq

INSERT INTO USER_TEST VALUES('QWERTY','1QWE',"test_seq".NEXTVAL) 

Second mistake is your insert statement is wrong, as your column name is not specified and your auto-generate field is on last in column list so you have to specify test_seq.NEXTVAL in last in insert statement

SEE Working Fiddle

---

Related Topics