oracle 备份文件*.dmp 还原步骤
1.SQLPLUS 创建用户和授权
登陆: system/manager as sysdba
创建用户\密码:create user eam_fuwa identified by eam_fuwa account unlock;
用户授权: grant connect,dba,imp_full_database to orcl;
2.进入cmd命令,imp导入数据库
进入cmd命令
进入imp命令所在路径 cd C:\app\jin.liu\product\11.2.0\dbhome_1\BIN
c:\users\jin.liu\imp eam_fuwa/eam_fuwa@orcl full=yes file=c:\fuwa.dmp