Re: Partitioning Problem
Posted by:
Rick James
Date: April 11, 2010 10:46PM
Why do you want to partition that way?
I think the reason that it is disallowing what you are trying is... To enforce UNIQUEness (of a PRIMARY KEY or UNIQUE key), it would have to check every partition on every INSERT. If you were partitioning on the emp_id, then it could do the check without hitting every partition.
Do you have a million employees? Are you dropping old employees? PARTITIONing a small tables doesn't buy much.
Subject
Views
Written By
Posted
3554
April 09, 2010 07:07AM
Re: Partitioning Problem
1758
April 11, 2010 10:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.