PL/SQL (MOSC)

MOSC Banner

DBMS_STATS.OBJECTTAB exlude list

edited Oct 18, 2019 5:00AM in PL/SQL (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center