Re: share sequences between tables or one to one

From: Doogie <jvivona_at_mindspring.com>
Date: 1997/12/10
Message-ID: <348F48B4.4E1D@mindspring.com>#1/1

No, but you need to change your code (I know it's obvious).

Also, I would wonder why the tables share the sequence. Hmmm there must be some type of data dependency.

Todd Storch wrote:
>
> 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