[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2065
  • Last Modified:

dbms_stats export stats to another database

i am going to copy stats from a database to a test database.

I will create the statistics table with
exec DBMS_STATS.CREATE_STAT_TABLE(ownname =>'SCHEMA_NAME' ,stat_tab => 'STATS_TABLE' , tblspace => 'STATS_TABLESPACE');

I need to know what tablespace to use? (should i create a new one only for stats) - some examples i've seen do not declare tablesapce.

Also, any tips on what parameters to use when using imp/exp to get stats_table into another database?
1 Solution
You dont need to create new tablespace for copying stats. Table will be created in dafult tablespace you have defined for that schema.
simply use EXPORT_TABLE_STATS Procedure
and IMPORT_TABLE_STATS Procedure. To extract and load your stats from production to Test Environment.


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now