Re: same sequence as primary key in more than one table
From: DeB <debashish.majumdar_at_gmail.com>
Date: Mon, 15 Jun 2009 03:41:28 -0700 (PDT)
Message-ID: <408213fe-6eee-48f1-afb7-130adb3b6dcb_at_z8g2000prd.googlegroups.com>
There wont be any issue as long as the the relationships between the tables are maintained. I've not seen such an approach in practice so far. You would be doing much better if you have a sequence for each table rather than having one.
Date: Mon, 15 Jun 2009 03:41:28 -0700 (PDT)
Message-ID: <408213fe-6eee-48f1-afb7-130adb3b6dcb_at_z8g2000prd.googlegroups.com>
There wont be any issue as long as the the relationships between the tables are maintained. I've not seen such an approach in practice so far. You would be doing much better if you have a sequence for each table rather than having one.
-- Cheers DeBReceived on Mon Jun 15 2009 - 05:41:28 CDT