工艺审查系统数据库恢复

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