RE: ORA-2289 - anyone?
Try this; GRANT DROP ANY SEQUENCE TO luser_name Or if you don't want to mess around; GRANT ALTER ANY SEQUENCE TO luser_name Dave -Original Message- Sent: Tuesday, January 21, 2003 8: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:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORA-2289 - anyone?
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:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: ORA-2289 - anyone?
Is there a trigger on the table which is referencing a non-existent sequence? Or a sequence to which the owner of the table has not been granted SELECT permission? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 7:19 AM 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:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORA-2289 - anyone?
Thank you all for your suggestions. And kindly excuse my abruptness. I was feeling a bit ignored ;) I find this list EXTREMELY useful and as a newbie, I am grateful for its existence. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 7:19 AM 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:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of