Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SPACE returns: ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SPACE", line 869

Shaamil_ASHJun 2 2015 — edited Jun 2 2015

Hi All,

My database is Oracle 11.2.0.4 4 node RAC.

I am trying to use DBMS_SPACE features to determin the wasted segments. I have granted select catalog role to <user> and

grant analyze any to <user>r;

grant execute on dbms_space to ,user>r;

But still an error throwing on the execution

Please help me to determine and implement this.

Regards, Shaamil.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2015
Added on Jun 2 2015
#general-database-discussions
1 comment
722 views