Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle bug when truncating thru a synonym(8.1.7)
short trip.....LOLOL!
>>> teci_dba1_at_hotmail.com 06/04/01 04:17PM >>>
This one is a good one:
8.1.7 on aix and linux for sure.
create table x(x number);
create synonym y for x;
truncate table y;
ORA-4020 DEADLOCK DETECTED
on 8.1.6
you get the correct message:
942-table or view not found.
Bug #1579190
Drove me nuts for a while :)
Joe
Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Joseph Testa INET: teci_dba1_at_hotmail.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To REMOVEyourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: sawmillert_at_state.mi.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Mon Jun 04 2001 - 14:47:21 CDT