create table newTable as select * from oldTable where 2=1;
--11g导出的dmp导入到10g
将导出的dmp文件放入到D:\oracle\product\10.2.0\admin\orcl\dpdump\下
impdp pd_shlzj_1016/1@orcl directory=data_pump_dir dumpfile=shlzj1016.dmp version=10.2.0.3.0
create table newTable as select * from oldTable where 2=1;
--11g导出的dmp导入到10g
将导出的dmp文件放入到D:\oracle\product\10.2.0\admin\orcl\dpdump\下
impdp pd_shlzj_1016/1@orcl directory=data_pump_dir dumpfile=shlzj1016.dmp version=10.2.0.3.0