oracle 导入导出
1准备:把空表也导出来(执行空表语句)
select 'alter table '||table_name||' allocate extent;' from tablesname where owner like 'username'
把 查询出来的语句 执行一遍
2:导入:imp username/password@orcl file=XXX.dmp full=y ignore=y destroy=y;
3:导出:exp username/password@orcl owner=RDP_LOG file=c:\jxgz0331.dmp