Oracle-L: RE: ORA-2289

From: Sherman, Edward <shermanej_at_eccic.com>
Date: Tue, 21 Jan 2003 07:39:31 -0800
Message-ID: <F001.00535F14.20030121073931@fatcity.com>

>From SQL*PLUS:

select sequence_name from dba_sequences;

Do the sequence names tt1462788_work_item_srl, tt1462788_tmp_asn_ship_srl, etc. show up in the list?

Log in to SQL*PLUS using the same account that the biora8x.cpp app uses to run SQL statements.
Are you able to create and drop sequences using that account? Are you able to drop and recreate the tt1462788_work_item_srl sequence from that account in SQL*PLUS?

>From what I can see so far it is probably a problem with privileges.

-----Original Message-----
Sent: Tuesday, January 21, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L

Let me try this one more time. We are running Oracle 8.1.7 and I received an ORA-2289 as indicated below.

Does anyone out there think he/she might be able to help me? Or at least point me in the right direction.

Thanks again.
Saira

-----Original Message-----
Somani
Sent: January 20, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L

Hi all,

I'm new at this game and am running into this Oracle error in our training environment.

I have searched on the web and the archives but I am not sure about a resolution to this issue. Any comments/insights would be appreciated.

After investigating the issue, I found that there is a crash when trying to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other temporary tables.

Here are the errors:

biora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_item_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_load_err_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470 > Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470 > Error code = 2289.

Here is the description of the 2289 error:

// *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.

 CUNAME:cu4
 STATUS:-255
 NATERR:-10000

ERRMSG:
PRGSQL:INSERT INTO tmp_asn_ship
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.
saira_somani_at_yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  INET: saira_somani_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  INET: saira_somani_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sherman, Edward
  INET: shermanej_at_eccic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jan 21 2003 - 09:39:31 CST

RE: ORA-2289 - anyone?