DMP文件导入

1.SQLPLUS SYS/SYS@ORCL AS SYSDBA;      //数据库连接

2.CREATE TABLESPACE OKAYAJAVA
   DATAFILE 'D:\ora\sofia_ora\OKAYAJAVA.ORA' SIZE 50M
   AUTOEXTEND ON NEXT 150M MAXSIZE UNLIMITED
   DEFAULT STORAGE(INITIAL 50M NEXT 25M
   MINEXTENTS 1 MAXEXTENTS 100 PCTINCREASE 0);                 //创建表领域

3.CREATE USER OKAYAJAVA IDENTIFIED BY OKAYAJAVA
   DEFAULT TABLESPACE OKAYAJAVA;                                            //创建用户

4.GRANT CONNECT,RESOURCE,IMP_FULL_DATABASE,EXP_FULL_DATABASE,ALL PRIVILEGES TO OKAYAJAVA;

      //权限

5.imp_okayajava.bat //执行bat文件