导入(备份还原)
最干净的方式是先把dmp归属用户删除,再重新创建用户:
drop user usernameXXX cascade;
create user username identified by passwordXXX default tablespace XXXXX;
grant dba to usernameXXX;
imp usernameXXX/passwordXXX@ip/orcl file=D:\DB_20200907.dmp full=y ignore=y;(如果本地安装有Oracle客户端,则用此命令可将本地dmp导入到远程服务器)
注:删除用户时可能会遇到存在未断开连接的用户而删除失败,需将连接的用户都断开:
查数据库哪些连接并选择需要断开的连接
username需大写:
select username,sid,serial# from v$session where username = ‘JEECG_TEST’;
alter system kill session ‘6,12’;