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?
You should not select Local Range, but instead select Global Range to set up a Partition using the steps below:
- Create a brand new Logical/Physical model with one entity containing attributes a, b, c,d,e,f, g
- Go to physical model, select index Properties, and click Partitions
- 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.
- Assign your columns and enter the values under the columns