| DBMS_STATS and ORA-20000 [message #536417] |
Tue, 20 December 2011 21:24  |
tmcallister
Messages: 107
Registered: December 2007
|
Senior Member |
|
|
I've just installed an Oracle 11.2.0.1.0 64 bit server on my windows 7 machine in order to play around with some probably futile thoughts in regards to the eternity ii puzzle.
Anyway, while using attempting to run
exec dbms_stats.gather_table_stats('eii','v2x4e')
I get the following:
ORA-20000: Unable to analyze TABLE "EII"."V2X4E", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 20327
ORA-06512: at "SYS.DBMS_STATS", line 20360
ORA-06512: at line 1
My initial google searches indicate that I need the select any table and analyze any privileges. I don't think that can be right/appropriate - but I've granted them anyway to no avail.
Additionally any thoughts of why
Select * from user_tables
returns tables in the System and sysaux tablespaces, but not my own schema/tablespace?
Thanks!
[Updated on: Tue, 20 December 2011 21:26] Report message to a moderator |
|
|
|
|
|
| Re: DBMS_STATS and ORA-20000 [message #536442 is a reply to message #536421] |
Wed, 21 December 2011 00:54  |
tmcallister
Messages: 107
Registered: December 2007
|
Senior Member |
|
|
BlackSwan wrote on Tue, 20 December 2011 21:19>returns tables in the System and sysaux tablespaces, but not my own schema/tablespace?
You must have been logged into the DB as SYSTEM.
No I've set up my own schema and tablespace, and quite clearly connected as eii/password@orcl.
But on second pass that seems to be an issue with toad. Connecting via sqlplus does not give the same result.
And on third glace that's the same reason dbms_Stats isn't working. Hmm something is strange with toad then. Nevermind. Same problem different forum  .
[Updated on: Wed, 21 December 2011 00:55] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
