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文件所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。