The same thing happened to me as well.
There were 2 rows in dual, and it caused some really
strange problems with Oracle Financials.
The support tech and Oracle knew his stuff, and had
me check it. I have no idea how 2 rows came to be
in dual, but it sure was a mess.
Jared
Stephane Paquette <stephane_paquette_at_yahoo.com>
Sent by: root_at_fatcity.com
12/17/2002 10:26 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: DUAL
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:
INET: Jared.Still_at_radisys.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 - 15:12:30 CST
