ORA-02332: cannot create index on attributes of this column ORACLE 报错 故障修复 远程处理

文档解释

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）;