Re: Analyzing all tables ?

you may use dbms_utility.analyze_schema procedure

sokol_at_opsb.ru wrote in message <6fi0oo$aoh$1_at_nnrp1.dejanews.com>...
>
>
>Use standard DBMS_DDL package with standard ALL_OBJECTS view
>
>if You haven't info about DBMS_DDL, I can mail You source of it.
>
>Sorry for bad English.
>
>Good Luck.
>
>In article <6fgd3h$32a$1_at_news.NL.net>,
> "Marco Nedermeijer" <m.n.nedermeijer_at_rtd.nl> wrote:
>>
>> Is it possible to analyze all tables, indexes and clusters (in one step)
 ?
>> Or must i write a script where all tables seperately are analyzed ?
>>
>> Thanks,
>>
>> Marco Nedermeijer
>> m.n.nedermeijer_at_rtd.nl
>>
>>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Mar 30 1998 - 00:00:00 CST