[Webinar] Streamline your web hosting managementRegister Today

x
  • 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?
0
plennon
Asked:
plennon
1 Solution
 
anandmahajanCommented:
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.

0
 
linuxoCommented:
0

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