Importing statistic on a partitioned table

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Mon, 13 May 2002 22:21:25 +0200
Message-ID: <ma70eu0f31pebtvj5qaai7dcd1bslsicun@4ax.com>

Hi,

I'm using Oracle 8.1.7 on Solaris 8

I'm trying to collect statistics on a benchmark database and importing them into our development database.

I'm encountering a problem with partitioned tables. Because we don't have the same partitions in both environment, I'm not able to import statistics, even not global statistics. When I try, I receive following message :

---

BEGIN DBMS_STATS.IMPORT_TABLE_STATS ( ownname => 'pin', tabname => 'X_EVENT_ACT_CONTENT_DEBIT_T', cascade => TRUE , stattab => 'PROD_STATS' ); END;

*
ERROR at line 1:
ORA-20000: Unable to set values for table X_EVENT_ACT_CONTENT_DEBIT_T: does not
exist or insufficient privileges

ORA-06512: at "SYS.DBMS_STATS", line 2954
ORA-06512: at "SYS.DBMS_STATS", line 3375
ORA-06512: at line 1


===========================================

(obviously, table exists, and user has DBA role) but what doesn't exist are all partitions.
What make me think that it's a problem with partitions is that, when I precise the name of a partition existing in both database, all is OK:

---

EXECUTE DBMS_STATS.IMPORT_TABLE_STATS ( ownname => 'pin', tabname => 'EVENT_T', partname => 'PARTITION_HISTORIC', cascade => TRUE , stattab => 'PROD_STATS' );

PL/SQL procedure successfully completed.

---

The problem is that I can't get global table statistics.

Is there a way to bypass this ?

Amicalement
Frédéric PAYANT Received on Mon May 13 2002 - 15:21:25 CDT