1.创建数据泵导出目录,并导出数据:
col owner for a22;
col directory_path for a66
set linesize 200
set pagesize 9999
select * from dba_directories
create directory expdp as 'E:\backup\expdp';
grant read,write on directory expdp to public;
grant imp_full_database to public;
2.数据导入(导入数据时监控归档日志满,及时rman清理):
导入时加上exclude=statistics :
impdp test/test directory=expdp dumpfile=test0923.DMP logfile=test0923imp.log exclude=statistics
3.导入后收集采样信息:
exec dbms_stats.gather_schema_stats(ownname=>'test',estimate_percent=>10,degree=>8,cascade=>true,granularity=>'ALL');或者:
begin
dbms_stats.gather_schema_stats(
ownname=> '"TEST"' , --改为现场test schema名称,要为大写名称
cascade=> TRUE,
estimate_percent=> null,
degree=> 2, #--CPU个数减2
no_invalidate=> DBMS_STATS.AUTO_INVALIDATE,
granularity=> 'AUTO',
method_opt=> 'FOR ALL COLUMNS SIZE AUTO',
options=> 'GATHER');
end;
/
数据泵导入步骤及导入后采样统计信息
最新推荐文章于 2023-09-08 16:24:22 发布