<div>
hi,<br />
<br />
here : &nbsp;<a href="http://www.dbasupport.com/oracle/ora9i/CBO4_6.shtml" rel="ugc">http://www.dbasupport.com/oracle/ora9i/CBO4_6.shtml</a><br />
<br />
<br />
thanx
</div>


hi,

here :  http://www.dbasupport.com/oracle/ora9i/CBO4_6.shtml [http://www.dbasupport.com/oracle/ora9i/CBO4_6.shtml]


thanx

<div>
<div class="content wysiwyg-content">
i am going to copy stats from a database to a test database.<br />
<br />
I will create the statistics table with<br />
exec DBMS_STATS.CREATE_STAT_TAB<wbr />LE(ownname<wbr /> =&gt;'SCHEMA_NAME' ,stat_tab =&gt; 'STATS_TABLE' , tblspace =&gt; 'STATS_TABLESPACE');<br />
<br />
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. <br />
<br />
Also, any tips on what parameters to use when using imp/exp to get stats_table into another database?
</div>
</div>


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?

dbms_stats export stats to another database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.