oracle导入导出

sqlplus system/system@egov
create directory dump_dir as 'd:\dbback';
exit;

expdp system/system@egov directory=dump_dir dumpfile=urbanyw.dmp schemas=urbanyw logfile=urbanyw_out.log

expdp system/system@egov directory=dump_dir dumpfile=urbandoc.dmp schemas=urbandoc logfile=urbandoc_out.log

expdp system/system@egov directory=dump_dir dumpfile=unieap.dmp schemas=unieap logfile=unieap.log

impdp system/system@egov directory=dump_dir dumpfile=urbanyw.dmp logfile=urbanyw_in.log

impdp system/system@egov directory=dump_dir dumpfile=urbandoc.dmp logfile=urbandoc_in.log

impdp system/system@egov directory=dump_dir dumpfile=unieap.dmp logfile=unieap_in.log

sqlplus system/system@egov
drop directory dump_dir;
exit;   

alter system set processes=800 scope = spfile;