I am trying to upgrade from 11.8.0 to 11.8.2 on test environment. When upgrading the DB schema version, it was OK to upgrade from 11.8.0 to 11.8.1. During upgrade from 11.8.1 to 11.8.2 using upgrade script WS-Upgrade-11.8.1-to-11.8.2.ora.sql, I am getting an error:
Error starting at line : 1,661 in command - declare cursor missing_indexes is select 'create index ' || 'IX_' || substr(c.table_name, 0, 6) || '_' || substr(cc.column_name, CASE WHEN LENGTH(cc.column_name) > 14 THEN LENGTH(cc.column_name) - 14 ELSE 0 END, LENGTH(cc.column_name))||'_' || dbms_random.STRING('O', 3) || ' on ' || c.table_name || ' (' || cc.column_name || ') ' create_index from dba_constraints c inner join dba_cons_columns cc on c.constraint_type = 'R' and cc.owner = c.owner and cc.constraint_name = c.constraint_name left join dba_ind_columns ic on ic.table_owner = c.owner and ic.table_name = c.table_name and ic.column_name = cc.column_name where c.owner in (SELECT sys_context('userenv', 'current_schema') FROM dual) and ic.index_owner is null order by c.table_name ; begin for create_function in missing_indexes loop dbms_output.put_line(create_function.create_index); execute immediate create_function.create_index; commit; end loop; END; Error report - ORA-00955: name is already used by an existing object ORA-06512: at line 27 ORA-06512: at line 27 00955. 00000 - "name is already used by an existing object"
|
