Database Administration (MOSC)

MOSC Banner

Whither this privilege?

edited Sep 11, 2020 9:37AM in Database Administration (MOSC) 7 commentsAnswered ✓

Oracle 12.1.0.2 SE2

Oracle Linux 6

Reading doc 2418576.1, under the section on MV before upgrade, it suggests the following query:

SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;

But logged on with my own account (to which has been granted DBA and a few other extras) it returned 'ORA-01031: insufficient privileges'.

Hmm.  So which of the three tables?  Let's see:

SQL> select count(*) from sys.obj$;  COUNT(*)----------    1020111 row selected.SQL> select count(*) from sys.user$;select count(*) from sys.user$                         *ERROR at line 1:ORA-01031: insufficient privilegesSQL> select count(*) from sys.sum$;

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