Cherie,
If you push F1 key from SqlPlus there will be a complete explanation called
'all about sequences and how to create them on dual table'.
-----Original Message-----
Sent: Tuesday, July 30, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
Dan,
Haven't heard the why yet but I think it may be just a poorly worded
request. I suspect he wants the sequences created on another table and
just wants to be able to select from dual. Maybe he never realized that
the sequences were actually created on another table. Maybe he actually
thought that the sequences were created on the DUAL table since he only
ever used them by selecting from DUAL. Our developers run quite a wide
gamut and I don't work very regularly with this one so it's hard to know
where he's coming from. Still trying to get him on the phone.
Thanks for this info about performance on DUAL. I will pass the info on.
Thanks to everyone for getting us all on the same page. I'm sure that
once I talk this out with him, it'll be straightened out quickly.
Cherie
"Fink, Dan"
<Dan.Fink@mdx. To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>,
com> "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc:
07/30/02 12:46 Subject: RE: Creating sequences
on the DUAL table?
PM
Cherie,
My first response is 'WHY?'. Do they mean that they want to
create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some
information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html.
Dan Fink
-----Original Message-----
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
I have a request from one of our developers to create two new sequences on
the DUAL table.
This seems like a bad idea to me. I've never had such a request in the
past. I asked for clarification on why this is needed and I didn't get a
lot of details yet.
Is this something that is standard operating procedure? My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.
Under what circumstances would it be justified to create sequences on the
DUAL table? Should I just flat-out refuse this request and if so, why?
Thanks,
Cherie Machler
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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:
INET: [EMAIL PROTECTED]
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: [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: Lyuda Hoska
INET: [EMAIL PROTECTED]
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: [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).
