Skip to Main Content
Forums

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!

could not gather statistics for locked objects

MoazzamJun 7 2010 — edited Jun 8 2010
I wanted to gather statistics for all tables in a schema on Oracle 10g Release 1.

For this, i used dbms_stats.gather_schema_stats but this procedure generates error if any table in schema is locked.

In Oracle 10g Release2, i can use a force parameter to get statistics of even locked tables but how can i do this in previous versions of Oracle (10g Release 1 and 9i)

Thanks,

Moazzam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2010
Added on Jun 7 2010
7 comments
1,770 views