brconnect question

Hello,

I would like to compute statistics for some specific tables in Oracle. For example I would like to compute statistics for all tables that start with A.

If I have understood the documentation, we should use the option:

-t|-table: Defines the objects to be processed by update statistics.

Input syntax: -t|-table all|all_ind|all_part|missing|harmful|dbstatc_tab|dbstatc_mon|

dbstatc_mona|[<owner>.]<table>|[<owner>.]<index>|[<owner>.]<prefix>*|<tablespace>|<object_list>|info_cubes|locked|system_stats|oradict_stats

So I have tried the following command:

brconnect -u / -c -f stats -t A* -m C

But it doesn't seem to work. If this doesn't work, is there an option for brconnect that allows us to not log the output in SAP (DB24, DB14, etc ...)

Rgds,

Youssef