SQL & PL/SQL

Hi all,
here there is my problem with this table:

CREATE TABLE CKEPM.CKCLASS_ALL
(
  DATA_POPOLAMENTO  DATE,
  OBJ_CAT           CHAR(1 BYTE),
  NODE_ID           NUMBER,
  CA_V              VARCHAR2(256 BYTE),
  CB_V              VARCHAR2(256 BYTE),
  C1                NUMBER,
  C2                NUMBER
 )
TABLESPACE TBS_CKEPM_ALL
PARTITION BY RANGE (DATA_POPOLAMENTO)
SUBPARTITION BY LIST (OBJ_CAT)
(  
  PARTITION ALL_20100130204500RQ VALUES LESS THAN (TO_DATE(' 2010-01-30 21:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    TABLESPACE TBS_CKEPM_ALL
  ( SUBPARTITION ALL_20100130204500RQL01 VALUES ('N')    TABLESPACE TBS_CKEPM_ALL,
    SUBPARTITION ALL_20100130204500RQL02 VALUES ('L')    TABLESPACE TBS_CKEPM_ALL ),  
  PARTITION ALL_20100130210000RQ VALUES LESS THAN (TO_DATE(' 2010-01-30 21:15:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    TABLESPACE TBS_CKEPM_ALL
  ( SUBPARTITION ALL_20100130210000RQL01 VALUES ('N')    TABLESPACE TBS_CKEPM_ALL,
    SUBPARTITION ALL_20100130210000RQL02 VALUES ('L')    TABLESPACE TBS_CKEPM_ALL )
);

CREATE BITMAP INDEX CKEPM.IX_CKCLASSALL_NODE ON CKEPM.CKCLASS_ALL
(NODE_ID)
  TABLESPACE TBS_CKEPM_ALLX
LOCAL (  
  PARTITION ALL_20100130204500RQ
    TABLESPACE TBS_CKEPM_ALLX
  ( SUBPARTITION ALL_20100130204500RQL01    TABLESPACE TBS_CKEPM_ALLX,
    SUBPARTITION ALL_20100130204500RQL02    TABLESPACE TBS_CKEPM_ALLX ),  
  PARTITION ALL_20100130210000RQ
    TABLESPACE TBS_CKEPM_ALLX
  ( SUBPARTITION ALL_20100130210000RQL01    TABLESPACE TBS_CKEPM_ALLX,
    SUBPARTITION ALL_20100130210000RQL02    TABLESPACE TBS_CKEPM_ALLX )
);

I need to gather statistics for the partitions/subpartitions/index partitions of <b>ALL_20100130204500RQ</b> and then copy all those statistics on <b>ALL_20100130210000RQ</b>

1) Could someone post the DBMS_STATS.gather_table_stats and DBMS_STATS.copy_table_stats script?

I have tried

exec DBMS_STATS.gather_table_stats (ownname               => 'CKEPM',
tabname               => 'CKCLASS_ALL',
partname              => 'ALL_20100130204500RQ', 
estimate_percent      => DBMS_STATS.AUTO_SAMPLE_SIZE ,
CASCADE               => FALSE);

select partition_name , last_analyzed
from user_TAB_PARTITIONS 
where partition_name IN ('ALL_20100130204500RQ, 'ALL_20100130210000RQ);

PARTITION_NAME	LAST_ANALYZED
ALL_20100130204500RQ	09/02/2010 8.56.20
ALL_20100130210000RQ	 

exec DBMS_STATS.copy_table_stats (ownname => 'CKEPM', 
tabname => 'CKCLASS_ALL', 
srcpartname => 'ALL_20100130204500RQ', 
dstpartname => 'ALL_20100130210000RQ');

ORA-06533: Subscript beyond count
ORA-06512: at "SYS.DBMS_STATS", line 16496
ORA-06512: at line 1

select partition_name , last_analyzed
from user_TAB_PARTITIONS 
where partition_name IN ('ALL_20100130204500RQ, 'ALL_20100130210000RQ);

PARTITION_NAME	LAST_ANALYZED
ALL_20100130204500RQ	09/02/2010 8.56.20
ALL_20100130210000RQ	09/02/2010 8.56.20 

2) When I make unusable the index and the rebuild it, I need also to gather statistics (how?) ?

Thanks to all,
Riccardo

Edited by: user12581838 on Feb 8, 2010 11:58 PM

Edited by: user12581838 on Feb 9, 2010 12:48 AM