oracle cmd 还原数据数据库

    xiaoxiao2022-07-12  150

    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;

    最新回复(0)