You are here:

Oracle/Error during Analyzing table

Advertisement


Question
Hi,

I have a package in USER_1 schema. The package usually creates many temporary tables during the execution and I have used dbms_stats to collect the statistics as given below. The package is executed from sys schema.
dbms_stats.gather_table_stats
ownname=> 'USER_1',tabname=> out_tabname,
estimate_percent=> DBMS_STATS.auto_sample_size,
degree=> 16);

During execution I got the below error.

ORA-20000: Unable to analyze TABLE "USER_1"."TMP_TAB_3", insufficient privileges or does not exist.

I checked that SYS is having ANALYZE ANY granted.

Please advise about the above error.

Thanks
Krishanu

Answer
Hello Krishanu,

Check the following links which might resolve your problem -

http://stackoverflow.com/questions/14624650/exec-gather-table-stats-from-procedu
http://www.oraclealchemist.com/news/when-errors-tell-you-absolutely-nothing/

Hope this helps.

Regards

Suchitra

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.