1.oracle还原dmp后缀的数据库
2.首先打开sqplus登陆 登陆名 as sysdba(不需要要输入密码)
3.脚本运行开始
这是创建语句 CREATE USER SJK IDENTIFIED BY 11111 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; 给权限 grant connect,resource,dba to SJK; 给路径
CREATE SMALLFILE TABLESPACE “SJK” DATAFILE ‘E:/ORACLEDATA/ORCL1/SJK.DBF’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 给权限 GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO SJK;
然后cmd运行导入就可以了 imp SJK /11111@orcl full=y file=E:\SJK .dmp ignore=y;