| ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index [message #417010] |
Wed, 05 August 2009 12:52  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I'm attempting to create a unique compound partitioned index and getting the below:
SQL> create unique index nonmem_unq_tony on tony(emailaddress, websiteid) local tablespace idx_test01;
create unique index nonmem_unq_tony on tony(emailaddress, websiteid) local tablespace idx_test01
*
ERROR at line 1:
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
Searching around, I find the explanation:
| Quote: |
Oracle Error :: ORA-14039
partitioning columns must form a subset of key columns of a UNIQUE index
Cause
User attempted to create a UNIQUE partitioned index whose partitioning columns do not form a subset of its key columns which is illegal
Action
If the user, indeed, desired to create an index whose partitioning columns do not form a subset of its key columns, it must be created as non-UNIQUE; otherwise, correct the list of key and/or partitioning columns to ensure that the index" partitioning columns form a subset of its key columns
|
Neither of these fields are my partition key. Is there any other way I can create a unique compound partitioned index on this table? Or, as I suspect, am I just out of luck?
Thanks.
[Updated on: Wed, 05 August 2009 13:03] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
