Error ORA-01408 when creating index

Cause:

index 已存在

Resolution

1. 查找index

select owner, index_name from dba_indexes where table_name='<table_name>';

2. 查找index的列名

select index_owner, index_name, column_name from dba_ind_columns where index_name ='<index_name>';

3. 删除index

drop index sap<sid>."<index_name>";