EBS导出导入统计信息

演练阶段,运行统计数据收集后导出统计信息:
Connect apps/apps
execute fnd_stats.backup_schema_stats('ALL','bz_2022');
exp userid=APPLSYS/apps file=fnd_stat_bz_2022.dmp \
tables=fnd_stattab log=fnd_stat_bz_2022.log
生产割接阶段导入统计数据信息:
imp userid=APPLSYS/APPS file=fnd_stat_bz_2022.dmp full=y \
ignore=y log=fnd_stat_bz_imp.log
Connect apps/apps
execute fnd_stats.restore_schema_stats('ALL','bz_2022');