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:\Administrator\virtual\oradata\orcl\MAXDATA.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:\Oracle\maximo.dmp    full = y;