SQL & PL/SQL

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!

Privilege for dbms_stats.gather_table_stats on a table

Parameshwaran DuraisamyNov 3 2016 — edited Nov 3 2016

Hi all,

I tried to execute the gather stats on a set of tables. But I am getting "insufficient privileges" error.

Kindly let me know how to check whether the privilege is available in that schema for the user and how to resolve it.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2016

Added on Nov 3 2016

2 comments

1,968 views