//1-2可解决空表dmp不导出问题
1-查询
select 'alter table '||table_name||' allocate extent;'
from user_tables where num_rows=0 or num_rows is null;
2-将查出的alter语句执行
3-导出示例(full=y为全用户导出,导出当前用户时,去掉)
exp dnaf_cmp/123456@127.0.0.1/orcl2 file=E:\tmp\oracle-tmp\export\business.dmp log=E:\tmp\oracle-tmp\export\business.log full=y
4-导入
imp 用户名/密码@orcl file=D:/rfd.dmp full=y ignore=y;