Hi Table,
for many many years ago, I read all the important Oracle manuals every
year (it was probably around six-eight on that reading list). I have
probably not done that so much since Oracle 11.
In the excellent Development Guide is the answers to many of my
questions. Yes, dropping a unique index makes views invalid if they
reference a column that existed in that index (is that necessary when
the view is created with read only, so no dml can happen through the
view) and after that chapter comes Using Edition-Based Redefinition.
The answers are out there :-)
Stay safe everyone and be happy!
/Jocke
