oracle11g导出为10g的数据备份
select * from dba_directories;// 默认的 DATA_PUMP_DIR 在 d:\oracle\product\10.2.0\admin\orcl\dpdumpcreate directory ams_dir as 'd:/ams_dbbak';//在linux下要让这个目录可被读写。expdp userid='sys/manager1@orcl as sysdba' schemas=ams directory=DATA_PUMP_DIR dumpfile=ams10g.dmp logfile=ams.log version=10.2.0.1.0expdp userid='sys/manager1@orcl as sysdba' schemas=cgy directory=DATA_PUMP_DIR dumpfile=cgy10g.dmp logfile=cgy.log version=10.2.0.1.0
impdp userid='sys/manager1@orcl as sysdba' schemas=ams directory=DATA_PUMP_DIR dumpfile=ams10g.dmp logfile=ams.log version=10.2.0.1.0
页:
[1]