????2???????????????

????Import STAT_TAB

???????????expdat.dmp??????????????????system????

impdp system/****@**** tables=(stat_tab) directory=dbaexport dumpfile=expdat.dmp logfile=import.log


????Import ???????

??????STAT_TAB????Import iquewb???????????????????????DBMS_STATS.IMPORT_SCHEMA_STATS??

BEGIN
dbms_stats.import_schema_stats(ownname=>??IQUEWEB????stattab=>??STAT_TAB????statid=>??IQUEWEB_20100526????statown=>??SYSTEM????force=>FALSE);
END;
/


?????????????????????????????????????????????DBA_OPTSTAT_OPERATIONS????У??????????????μ????????????????Import??????????????iqueweb?μ???????????????????????

???????μ????

????????μ?????????????

alter session set nls_timestamp_tz_format=??yyyy-mm-dd hh24:mi:ss??;
col start_time format a14
col end_time format a14
col operation format a30
col target format a30
set linesize 120
select operation??target??start_time??end_time from dba_optstat_operations;
gather_database_stats(auto) 2010-05-15 06: 2010-05-15 06:
00:03 06:55
OPERATION           TARGET  START_TIME           END_TIME
------------------------------ ------------------------------
import_schema_stats IQUEWEB 2010-05-26 10: 2010-05-26 10:44:14 44:54


?????????????????????????????????iqueweb?μ???????????μ?????????

select table_name??num_rows??blocks??empty_blocks??avg_row_len??last_analyzed from dba_tables where owner=??IQUEWEB??;


??????????????????????????????????????????????????????????????????Import?????Oracle??Import???????????????????????????????skipped??