Before exporting statistics, you first need to create a table for holding the statistics. This statistics table is created using the procedure
DBMS_STATS.CREATE_STAT_TABLE. After this table is created, then you can export statistics from the data dictionary into your statistics table using the
DBMS_STATS.EXPORT_*_STATSprocedures. The statistics can then be imported using the
In order to move statistics from a snapshot standby database to a primary database, you must first export the statistics on the first database, then copy the statistics table to the second database, using the
IMPutilities or other mechanisms, and finally import the statistics into the second database.