oracle dmp导入

impdp test2/test2 directory=DBTEMP remap_schema=ics:test2 dumpfile=ICS2016-08-11.DMP logfile=imp_ics'%TE:~0,4%-'%TE:~5,2%-'%TE:~8,2%.log

去除’

 

drop user ice cascade;
create user ice identified by ice default tablespace QMYS_ICE temporary tablespace INTCUBE_TMP profile default ;
grant connect,resource,dba to ice;