oracle创建用户

-- Create the user 
create user diego identified by diego --用户名和密码
  default tablespace USERS  --表空间
  temporary tablespace TEMP  --临时空间
  profile DEFAULT
  password expire; --密码有效
-- Grant/Revoke role privileges   授权
grant connect to diego with admin option;
grant dba to diego;
grant resource to diego;
-- Grant/Revoke system privileges 
grant unlimited tablespace to diego;

导入dmp文件

imp diego/diego@127.0.0.1/diego file=E:\personalFiles\pdm\diego.dmp log=E
:\personalFiles\pdm\diego.log fromuser=abc touser = diego