Hi!

I'm using DBMS_STATS in my DB.

Some tables are very huge, because of which the TEMP space is never enough & the stats do not complete. So part of my DB is analyzed & part isn't.

I need to know if there is a procedure or such, that I can use to pass the table names to dbms_stats, so I can specify which tables to analyze & which to skip.

Thanks.