Well, there could be business logic reasons as to why you would have one sequence per table. Also, I don't know if I would ever go with one sequence for many tables, sounds like a bottle neck to me. And how would one sequence for many tables impact scalability?? Or having lots of users hammering the database?? And what happens if you have to reset the sequence, then you have to check the primary key values on many tables. One sequence to one table sounds good to me, but I would love to hear pros/cons about this...
-----Original Message----- Sent: Wednesday, July 16, 2003 3:35 PM To: Multiple recipients of list ORACLE-L no table "uses" a sequence. And there is no reason (other than sanity checks) to have one sequence per table. SQL code will use the sequence, usually to retrieve a value from the sequence to then insert into or update a column in a table. --- Mitchell <[EMAIL PROTECTED]> wrote: > Hi All > > At first I thought it is easy to find those tables to use sequences > but > I failed. dba_sequence don't give too much info. Is there any idea? > > Thanks in advance > Mitchell > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com <http://sbc.yahoo.com> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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).
<<attachment: winmail.dat>>
