Re: Yet Another Partitioned Table Question ... Example Included

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Wed, 29 Nov 2006 21:57:02 GMT
Message-ID: <Omnbh.10932$yE6.1221@newssvr14.news.prodigy.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1164824308.676140_at_bubbleator.drizzle.com...
>
> One clarification requested.
>
> Is it your intention to partition and create a primary key based on a
> column that will be updated and whose value will change over time?
>
> If so I would not recommend it.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

No. This is a history table so there will only be inserts into the table.

Values may change but they will change in the main table that this table is keeping a history for and any changes to the main table will be a new row in the history table. Received on Wed Nov 29 2006 - 15:57:02 CST