Skip to main content

ORA-02289 SEQUENCE DOES NOT EXIST


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Note: here we are trying to insert  values in a table from another user Which has access.

SQL 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.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

generating query is not having SCHEMA NAME suffixed before the SEQUENCE NAME. Please see below example’s for easy understanding.

Please see painted values in the below queries.

SQL> show user;
USER is "RKPYTE"

FAILING SQL:

SQL> insert into RKPYTE.TRANSACTION_IMPORT(TRANSACTION_IMPORT_ID,IMPORT_RUN_CODE,SOURCE_TRANSACTION_ID,DELIVERY_METHOD_CODE,TRANSACTION_DATE,PATRON_ACCOUNT_ID) values(TRANSACTION_IMPORT_ID_SEQ.nextval,'DEC31','6788','MAIL',sysdate,'164063');
insert into RKPYTE.TRANSACTION_IMPORT(TRANSACTION_IMPORT_ID,IMPORT_RUN_CODE,SOURCE_TRANSACTION_ID,DELIVERY_METHOD_CODE,TRANSACTION_DATE,PATRON_ACCOUNT_ID) values(TRANSACTION_IMPORT_ID_SEQ.nextval,'DEC31','6788','MAIL',sysdate,'164063')
                                                                                                                                                                   *
ERROR at line 1:
ORA-02289: sequence does not exist

RIGHT SQL:

SQL> insert into RKPYTE.TRANSACTION_IMPORT(TRANSACTION_IMPORT_ID,IMPORT_RUN_CODE,SOURCE_TRANSACTION_ID,DELIVERY_METHOD_CODE,TRANSACTION_DATE,PATRON_ACCOUNT_ID) values(RKPYTE.TRANSACTION_IMPORT_ID_SEQ.nextval,'DEC31','6788','MAIL',sysdate,'164063');

1 row created.

Thank You!!


Comments

Post a Comment

Popular posts from this blog

ORA-28007: THE PASSWORD CANNOT NE REUSED

             - Here will see how to deal with  => ORA-28007: the password cannot be reused -  I got a request from client user, stating his account has been locked. When I check the status of the account I found the below. connect to SYS user & execute the below query of that database. SQL> select password,username,account_status,profile from dba_users where username='TEST'; PASSWORD               USERNAME   ACCOUNT_STATUS                 PROFILE ------------------             ----------------  -------------------------------           -------------------- AB2Aa8AC9971521e3     TEST       EXPIRED(GRACE)&LOCKED    NONAPP_USERS So, then I have unlocked the account and checked the same again & I found the below results. ...
Post a Comment
Read more

CHANGING DBID FOR ORACLE DATABASE 11G

C:\Users\computer>sqlplus SQL*Plus: Release 11.1.0.7.0 - Production on Thu Sep 10 21:03:33 2013 Copyright (c) 1982, 2008, Oracle.  All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select dbid from v$database;       DBID ---------- 2188161033 SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options C:\Users\computer>nid DBNEWID: Release 11.1.0.7.0 - Production on Thu Sep 10 21:04:44 2013 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET ...
Post a Comment
Read more