创建表空间:
create tablespace unieap
datafile 'D:/APP/Administrator/oradata/orcl/urbandoc.dbf' size 100M
autoextend on next 1M maxsize 1000M
extent management loca
sqlplus system/system@orcl
create directory dump_dir as 'd:/dbback'
expdp system/system@orcl directory=dump_dir dumpfile=unieap.dmp schemas=unieap logfile=unieap_out.log;
expdp system/system@orcl directory=dump_dir dumpfile=urbanyw.dmp schemas=urbanyw logfile=urbanyw_out.log;
expdp system/system@orcl directory=dump_dir dumpfile=urbandoc.dmp schemas=urbandoc logfile=urbandoc_out.log;
sqlplus system/system
drop directory dump_dir;
exit
impdp system/system@orcl directory=dump_dir dumpfile=unieap.dmp logfile=unieap_in.log;
impdp system/system@orcl directory=dump_dir dumpfile=urbanyw.dmp logfile=urbanyw_in.log;
impdp system/system@orcl directory=dump_dir dumpfile=urbandoc.dmp logfile=urbandoc_in.log;