Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> share sequences between tables or one to one

share sequences between tables or one to one

From: Todd Storch <todd.storch_at_wang.com>
Date: 1997/12/10
Message-ID: <01bd057e$36b85470$fa0c7c96@tgs75984>#1/1 







I inherited a schema that uses sequences that are shared between tables. 
When a sequence needs to be recreated I have to check the MAX value for
several tables then set the start value of the sequence.  This can be time
consuming when many tables use the same sequence.  Is there any down side
to creating a sequence for each table in the schema. i.e. TABLENAME_SEQ ?




Thanks



Todd Storch


Wang Health Care


600 Technology Park Drive


Billerica, MA 01821


todd.storch_at_wang.com
Received on Wed Dec 10 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US