| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Creating sequences on the DUAL table?
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_at_mdx. To: "'ORACLE-L_at_fatcity.com'"
<ORACLE-L_at_fatcity.com>,
com> "'Cherie_Machler_at_gelco.com'"
<Cherie_Machler_at_gelco.com>
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
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: Cherie_Machler_at_gelco.com 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-LReceived on Tue Jul 30 2002 - 14:45:50 CDT
(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: Cherie_Machler_at_gelco.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska INET: lhoska_at_ilap.army.mil 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).
 |
 |