Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> export/import partition statistics

export/import partition statistics

From: amonte <ax.mount_at_gmail.com>
Date: Tue, 18 Sep 2007 15:49:54 +0200
Message-ID: <85c1fb130709180649q1bd3d5eo40ad13c05563a2cd@mail.gmail.com>


Hi

Is it possible export a partition statistics and import to another partiton (in the same table)? I have tried it but doesnt seem to work in 9.2.0.8, or may be never worked but to be honest have not tried before.

select table_name, partition_name, num_Rows from user_tab_partitions;

TABLE_NAME                     PARTITION_NAME                   NUM_ROWS
------------------------------ ------------------------------ ----------
GTADEPT                       GTADEPT1                                0
GTADEPT                       GTADEPT2                                0
GTADEPT                       GTADEPT3                                1
GTADEPT                       GTADEPT4                                6
GTADEPT                       GTADEPT5                                4
GTADEPT                       GTADEPT6                                6
GTADEPT                       GTADEPT7                                0
GTADEPT                       GTADEPT8                                0
GTADEPT                       GTADEPT9                                0


exec dbms_stats.export_table_stats('SCOTT', 'GTADEPT', 'GTADEPT5',
'TABSTATS')
exec dbms_stats.import_table_stats('SCOTT', 'GTADEPT', 'GTADEPT9',
'TABSTATS')
select table_name, partition_name, num_Rows from user_tab_partitions;

TABLE_NAME                     PARTITION_NAME                   NUM_ROWS
------------------------------ ------------------------------ ----------
GTADEPT                       GTADEPT1                                0
GTADEPT                       GTADEPT2                                0
GTADEPT                       GTADEPT3                                1
GTADEPT                       GTADEPT4                                6
GTADEPT                       GTADEPT5                                4
GTADEPT                       GTADEPT6                                6
GTADEPT                       GTADEPT7                                0
GTADEPT                       GTADEPT8                                0
GTADEPT                       GTADEPT9                                0


TIA

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 18 2007 - 08:49:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US