oracle11g导出空表无法导出处理

1.执行sql

Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or num_rows is null；

2.执行查询结果

导出：exp username/password@ip:port/orcl owner=username file=F:/dmpName.dmp

导入：imp username/password@ip:port/orcl file=F:/dmpName.dmp full=y

转载于:https://my.oschina.net/u/3770699/blog/3062449