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 <adar76_at_inter.net.il> 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:babette_at_rogers.com]
> > 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_at_Ashleyfurn
> To: Multiple
> > recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > iture.com>
> cc:
> > Sent by:
> Subject: DUAL
> > root_at_fatcity.com
> >
> >
> > 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: DFarnsworth_at_Ashleyfurniture.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).
> >
> >
> >
> >
> >
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>
>
> > >>>>>>>>>>>>>>
> > >>>>
> > 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: mrichard_at_transurban.com.au
> >
> > 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.com
> > --
> > Author: Babette Turner-Underwood
> > INET: babette_at_rogers.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).
>
=== message truncated ===
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
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: stephane_paquette_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.com
--
Author: Richard Ji
INET: richard.ji_at_mobilespring.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 Dec 17 2002 - 13:39:48 CST