mark一下,免得老忘:
create tablespace MDCS datafile '&1\MDCS.dbf' size 100m autoextend on next 10m;
create tablespace pt6 datafile '&1\pt6.dbf' size 100m autoextend on next 10m;
create user MDCS identified by cape default tablespace MDCS;
create user pt6 identified by cape default tablespace pt6;
--赋权限
grant dba to MDCS;
grant dba to pt6;
cmd中运行
impdp MDCS/cape@MDCS dumpfile=xx.dmp schemas=mdcs,pt6
xx.dmp需要放在D:\app\lihy\virtual\admin\MDCS\dpdump路径下
但是在AIX中有区别
--aix中默认的导入位置在/oracle/product/10.0.2/rdbms/log
AIX中不能有括号
impdp MDCS/cape@MDCS dumpfile=20181031.dmp schemas=mdcs,pt6