update fails
I checked it more than once, and I don't understand it:
Doing an update, then checking the updated value, and finding it not updated (but still the old value). I know these are special tables (it's Support that asked me to run this statement).
Why is it not working correctly ?
Both statements are performed directly after each other, same session:
SQL> update sys.metaview$ set properties = 137 where viewname = 'KU$_EXP_PKG_BODY_VIEW';
1 row updated.
SQL> select viewname,properties from sys.metaview$ where viewname = 'KU$_EXP_PKG_BODY_VIEW';
VIEWNAME
--------------------------------------------------------------------------------
PROPERTIES
----------
KU$_EXP_PKG_BODY_VIEW
1161
SQL>