Whither this privilege?
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$;