Toad 12.7.0.16b x64 (11.2.0.3 client against 11.2.0.3 DB)
Create index interface, when error appear, has untidy output:
SQL> set define offSQL> CREATE UNIQUE INDEX AUX_DEV.UQX ON AUX_DEV.OBJECT_LIST
(OBJECT_NAME, OBJECT_TYPE, OBJECT_DB_SCHEME)CREATE UNIQUE INDEX AUX_DEV.UQX ON AUX_DEV.OBJECT_LIST
(OBJECT_NAME, OBJECT_TYPE, OBJECT_DB_SCHEME)
Error at line 3
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Script Terminated on line 3.
should be:
SQL> set define off
SQL> CREATE UNIQUE INDEX AUX_DEV.UQX ON AUX_DEV.OBJECT_LIST
Brg
Damir