refresh stats problem

From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Wed, 11 Aug 2010 02:26:09 -0700 (PDT)
Message-ID: <02e1929a-21a1-4f20-88a6-017d5c422ff6_at_x21g2000yqa.googlegroups.com>

Oracle 10.2.0.4 enterprise on windows

I wanted to rebuild stats on server b ( copy ) from a saved table on server b

Note:- stats have been exported into HIMSDBA.STATTAB

On server B

1. CREATE TABLE LIVE.CJBTAB AS SELECT * FROM HIMSDBA.STATTAB_at_SERVERA WHERE D1 < TO_DATE('15/07/2010','DD/MM/YYYY') AND STATID LIKE 'LIVE%';
2. BEGIN DBMS_STATS.delete_schema_stats('LIVE'); END;
3. BEGIN DBMS_STATS.IMPORT_SCHEMA_STATS('LIVE','CJBTAB',NULL,'LIVE'); END;

I was hoping that the process would recreate histograms / table stats but it doesn't seem to have worked

Could anyone advise on if what I am trying should work or if I've missed something?

cheers
Chris B Received on Wed Aug 11 2010 - 04:26:09 CDT