DBA Hub

📋Steps in this guide1/1

Export import statistics

--- Create staging table to store the statistics data

oracle configurationintermediate
by OracleDba
13 views
1

Export import statistics

Code/Command (click line numbers to comment):

1
2
3
4
5
6
--- Create staging table to store the statistics data
exec dbms_stats.create_stat_table(ownname => 'SCOTT', stattab => 'STAT_BACKUP',tblspace=>'USERS');
-- Export stats
exec dbms_stats.export_table_stats(ownname=>'SCOTT', tabname=>'EMP', stattab=>'STAT_BACKUP', cascade=>true);
-- Import stats
exec dbms_stats.import_table_stats(ownname=>'SCOTT', tabname=>'EMP', stattab=>'STAT_BACKUP', cascade=>true);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!