I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that.
Richard Ji -----Original Message----- Sent: Tuesday, December 17, 2002 1:26 PM To: Multiple recipients of list ORACLE-L I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar <[EMAIL PROTECTED]> a �crit : > RE: DUALSo listen up: For better April 1'st - add > another record to dual. That is known to cause a > deteriorating effect on developers. > > :-) > > Yechiel Adar > Mehish > ----- Original Message ----- > From: Jeremy Pulcifer > To: Multiple recipients of list ORACLE-L > Sent: Monday, December 16, 2002 6:29 PM > Subject: RE: DUAL > > > Careful. We are listening. > > ;-) > > (that woulda messed me up for a while) > > > -----Original Message----- > > From: Babette Turner-Underwood > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, December 13, 2002 12:04 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: DUAL > > > > > > Thanks for the great suggestion! > > I will remember to use that one when > > those developers start getting too lippy ;-) > > > > Babette > > -----Original Message----- > > Richard > > Sent: Thursday, December 12, 2002 4:14 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Howdy, > > > > I believe that truncating DUAL has also been > known to leave developers > > scratching their head. Of course I could never > recommend > > that anyone try > > it though. > > > > > > > > > > "Farnsworth, Dave" > > <DFarnsworth@Ashleyfurn > To: Multiple > > recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > iture.com> > cc: > > Sent by: > Subject: DUAL > > [EMAIL PROTECTED] > > > > > > 13/12/2002 05:14 > > Please respond to > > ORACLE-L > > > > > > > > > > > > > > Hallo, > > > > Problems with dual, please read link > > > > > http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 > > > 497,00.html > > > > TIA, > > > > Dave > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > 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). > > > > > > > > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>> > > > >>>>>>>>>>>>>> > > >>>> > > Privileged/Confidential information may be > contained in > > this message. > > If you are not the addressee indicated > in this message > > (or responsible for delivery of the > message to such person), > > you may not copy or deliver this > message to anyone. > > In such case, you should destroy this message > and kindly > > notify the sender > > by reply e-mail or by telephone on > (61 3) 9612-6999. > > Please advise immediately if you or your > employer does not > > consent to > > Internet e-mail for messages of > this kind. > > Opinions, conclusions and other > information in this message > > that do not relate to the official > business of > > Transurban City Link > Ltd > > shall be understood as neither given > nor endorsed by it. > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>> > > > >>>>>>>>>>>>>> > > >>>> > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Mark Richard > > 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.com > > -- > > Author: Babette Turner-Underwood > > 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). > === message truncated === ===== St�phane Paquette DBA Oracle et DB2, consultant entrep�t de donn�es Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __________________________________________________________ L�che-vitrine ou l�che-�cran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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.com -- Author: Richard Ji 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).
