ORA-02332: cannot create index on attributes of this column
Cause: An attempt was made to create an index on an attributes of an object type column.
Action: Do not specify the index on the attribute.
答:这是一个Oracle错误,提示不能在特定列的属性上创建索引。
1、 SQL> ALTER TABLE customers DROP PRIMARY KEY index_name;
2、 SQL> ALTER TABLE customers ADD PRIMARY KEY(Customer_No, Customer_Name);
3、 SQL> ALTER TABLE customers ADD INDEX Customer_Name_Index (Customer_name);