Toad World® Forums

Untidy output in index creation error (small bug)

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