mcdonac@cust9 select * from v$version;
BANNER
Oracle9i Enterprise Edition Release 9.0.1.3.0 -
Production
PL/SQL Release 9.0.1.3.0 - Production
CORE9.0.1.2.0 Production
TNS for Solaris: Version 9.0.1.3.0 - Production
There is a difference in how privileges are handled in anonymous PL/SQL blocks vs.
stored procedures, packages etc. I should have made it more clear that this was not
from an anonymous block, but from a package.
Ian
-Original Message-
Sent: Wednesday, May 22, 2002 2:38 AM
To:
That's probably it. I'll bounce the database this evening and change the parameter.
I did try granting select directly on one of the sys tables, and ran the procedure to
gather space information on that one table. This time the table was found, but the
call to dbms_space.unused_space
I am in the process of moving a small database to Oracle 9.0.1.3. I have installed my
own space management spaces. It measures growth of objects and tablespace usage and
works well in Oracle 8i. The package does not work well with the 9i SYS tables; it
returns table or view does not exist,
Ian,
Probably the O7_DICTIONARY_ACCESSIBILITY parameter which is set to FALSE by
default in 9i is causing you problems.
It defaulted to TRUE in prior releases. When set to FALSE, it will not allow
'select any table' to work on SYS owned tables. However, access to tables
owned by other schemas is