how to exclude table from gather_schema_stats

have two methods

1. Lock the table stats for excluded from list of gather stats job.

--lock

 exec dbms_stats.lock_table_stats('USER','TEST');

 exec dbms_stats.gather_schema_stats( ownname => 'USER');

--unlock

 exec dbms_stats.unlock_table_stats('USER','TEST');

2. Change the PUBLISH parameter for table to FALSE value with SET_TABLE_PREFS

check PUBLISH parameter value

----DBMS_STATS.get_prefs('parameter','schema_name', 'table_name' )

SELECT DBMS_STATS.get_prefs('PUBLISH','USER', 'TEST' ) FROM dual;

--EXEC dbms_stats.set_table_prefs('Schema_name', 'table_name', 'parameter', 'false');

exec dbms_stats.set_table_prefs('USER', 'TEST', 'PUBLISH', 'false');

 exec dbms_stats.gather_schema_stats( ownname => 'USER');

SELECT table_name,to_char(last_analyzed,'DD-MON-YYYY HH24:MI:SS') "LASTANALYZED" from ALL_tables where owner='USER'