Unwanted Changes on Indexes

D.Wenzel

Member²
Servus,
we use PL/SQL Developer Version 13.0.6.1911.

We found unwonted Edits on Indexes.

1. open a Table to edit Table
38373302zu.png


Code:
.. RKOMP_ID, RMEA_ID, REIHT_ID, RME_ID, DECODE(DEFAULT_JN,'J','J',TO_CHAR(ID)) ..

2. Klick on definded Index on the tree point button

38373299qj.png


3. the edit dialog is opend and display as one line now lower
Code:
DECODE(DEFAULT_JN,'j','j',TO_CHAR(ID))

4. do Nothing and close with OK!
in the background still waitung a ddl with the lower Values

Code:
drop index..
create index .. RKOMP_ID, RMEA_ID, REIHT_ID, RME_ID, DECODE(DEFAULT_JN,'j','j',TO_CHAR(ID)) ..

38373301sx.png


Problem: if a made additional real changes and press apply and do not take a look in the real DDL - my function based index ist wrong - in my case it was a unique index that goes wrong :cry:

Yours Daniel

/update - images
 
Last edited:
Back
Top