Hello,
indexes and constraints are in different namespaces, therefore it should be possible to assign them the same name.
In the following case this is apparently not working:
create unique index orders_year_show_uq
on orders (year desc, show_orders asc);
alter table orders
add constraint orders_year_show_uq unique (year, show_order);
When I execute these statement, I get an "SQL Error: ORA-00955: name is already used by an existing object".
If I clean up and I execute the same statements as above with the only difference on line 2, using "year asc" instead of "year desc":
on orders (year asc, show_orders asc);
then it successes.
I cannot explain it, do you have any idea?
Thanks in advance.
Kind regards
Giovanni