管理员登录orcl:
sqlplus / as sysdba
创建用户:
create user user_name identified by user_password;
授权用户:
grant dba to user_name;
导入dmp文件:
imp user_name/user_password@orcl file=d:/shujuku.dmp full=y;
导出dmp文件:
exp user_name/user_password@orcl file=d:shujuku.dmp;
导出服务器dmp到本地:
exp user_name/user_password@服务器ip:orcl端口/orcl file=D:/name.dmp
删除用户:
DROP USER 用户名 CASCADE