ORA-02332: cannot create index on attributes of this column

文档解释

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

你可能感兴趣的