Backup Database stats:-
a)Create the STATS table only one time.
EXEC DBMS_STATS.CREATE_STAT_TABLE(ownname=> 'SYS',stattab=>'DB_NAME_STATS');
b) Export the full database stats as below.
exec dbms_stats.EXPORT_DATABASE_STATS(STATTAB=>'DB_NAME_STATS',statid=>'DB_NAME_STATS_2SDATE',STATOWN=>'SYS');
Please change the above steps as per requirement.
a)Create the STATS table only one time.
EXEC DBMS_STATS.CREATE_STAT_TABLE(ownname=> 'SYS',stattab=>'DB_NAME_STATS');
b) Export the full database stats as below.
exec dbms_stats.EXPORT_DATABASE_STATS(STATTAB=>'DB_NAME_STATS',statid=>'DB_NAME_STATS_2SDATE',STATOWN=>'SYS');
Please change the above steps as per requirement.