DBMS_STATS.OBJECTTAB exlude list
Hi
I am looking to exclude few table patterns using DBMS_STATS.OBJECTTAB. For example below, it include SYS% tables, but I want exclude those tables. Will that be possible?
DECLARE
filter_lst DBMS_STATS.OBJECTTAB := DBMS_STATS.OBJECTTAB();
BEGIN
filter_lst.extend(1);
filter_lst(1).objname := 'SYS%';
DBMS_STATS.GATHER_SCHEMA_STATS(NULL, obj_filter_list => filter_lst, options => 'GATHER AUTO');
END;
/
Thanks
Steve