Description:

I am attempting to set up local-range partitions on my indexes for Oracle 11g using ERwin r9.x. I selected Local Range for Index, however, I am not able to enter the range for the partition.  Why?

Solution:

You should not select Local Range, but instead select Global Range to set up a Partition using the steps below:

1. Create a brand new Logical/Physical model with one entity containing attributes a, b, c,d,e,f, g
2. Go to physical model, select index Properties, and click Partitions
3. Type your partition name and make sure to choose Global – Range (not Local range) and also an index that is not set up as a bitmap index.
4. Assign your columns and enter the values under the columns