Database Administration (MOSC)

MOSC Banner

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center