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!

analyze all tables of one schema

516171Aug 25 2006 — edited Aug 27 2006

hi,
the analyze table command is:
analyze table hr.employees compute statistics;

Now I want analyze all tables in the hr schema
how can I do it in a easy way,

thanks,
Zhiwei.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2006

Added on Aug 25 2006

#general-database-discussions

14 comments

27,648 views