Re: RAC partitioning question

On 1/31/2012 10:24 AM, Greg Rahn wrote:
> Any reason not to just add the date/timestamp column into the PK and make
> it two columns? This would result in allowing the index to be local (the
> date col is the partition key col) without any modification to the current
> table definition.
> On Tue, Jan 31, 2012 at 8:42 AM, Tim Gorman<tim_at_evdbt.com> wrote:
>
>> Jed,
>> Why not get rid of the sequence-generated PK column and instead make
>> another NUMBER column the PK, itself generated both from the needed
>> timestamp appended to a sequence generated data value to ensure it's
>> uniqueness? If you have that, then you can RANGE partition on that
>> NUMBER value according to your data manipulation requirements and also
>> have a LOCAL partitioned index so that you have no GLOBAL index issues.
>>
>>

-- 
Tim Gorman
consultant ->  Evergreen Database Technologies, Inc.
postal     =>  PO Box 352151, Westminster CO 80035
website    =>  http://www.EvDBT.com/
email      =>  Tim_at_EvDBT.com
mobile     =>  +1-303-885-4526
fax        =>  +1-303-484-3608
Lost Data? =>  http://www.ora600.be/ for info about DUDE...

--
http://www.freelists.org/webpage/oracle-l