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!

Analyze table on synonyms

258464Jan 8 2003 — edited Jan 10 2003

Hi All,

Is there a way to use analyze table without specifying the schema name when I am not the schema owner?

I have create a public synonym and have granted myself analyze any privileges.

SQL> analyze table mySchema.myTable compute statistics;

Table analyzed.

SQL> analyze table myTable compute statistics;
analyze table myTable compute statistics
*
ERROR at line 1:
ORA-00942: table or view does not exist

Many thanks,

Ed.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2003

Added on Jan 8 2003

6 comments

415 views