oracle数据的导入导出 等

创建表空间：

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;