oracle导入dmp文件

create user 用户名 identified by 口令[即密码];
create user xhmaximo identified by xhmaximo; 

grant connect, resource to 用户名;
grant connect, resource,dba  to xhmaximo  ; 
grant create trigger to xhmaximo  
grant create session to xhmaximo ; 
grant create sequence to xhmaximo  ;
grant create synonym to xhmaximo  ;
grant create table to xhmaximo  ;
grant create view to xhmaximo  ;
grant create procedure to xhmaximo ; 
grant alter session to xhmaximo  ;
grant execute on ctxsys.ctx_ddl to xhmaximo ;
grant create job to xhmaximo  ;
grant dba to xhmaximo  ;
alter user xhmaximo  default role all;

create tablespace MAXDATA datafile 'E:AdministratorvirtualoradataorclMAXDATA.DBF' size 200M autoextend on next 50m maxsize 20480m ;

alter user xhmaximo  default tablespace xhmaximo  quota unlimited on xhmaximo  ;

imp xhmaximo/xhmaximo@orcl  file =E:Oraclemaximo.dmp    full = y; 
 

最后

以上就是冷傲长颈鹿最近收集整理的关于oracle导入dmp文件的全部内容，更多相关oracle导入dmp文件内容请搜索靠谱客的其他文章。