Oracle导入操作实例

一般导入

imp still/still@still file=D:\20141110.dmp full=y

数据泵导入

create directory dir_dp as 'D:\oracle\dir_dp';grant read,write on directory dir_dp to c##gdpems;

将数据dmp文件放到directory目录里

impdp c##gdpems/gdpems directory=dir_dp dumpfile=JXNW20170217.DMP REMAP_SCHEMA=pemsnw0915:c##gdpems,exchange_user:c##exchange_user