oracle 删除用户，创建用户，导入dmp文件

1. sqlplus /  as sysdb

2. 如果drop user ids_test cascade;无法删除用户执行

select username,sid,serial# from v$session ;
alter system kill session '22,804'

3. 删除用户

drop user ids_test cascade;

4. 创建用户 

create user ids_test identified by glaway123

5. 授权，尤其是dba权限要单独给

grant all privilege to ids_test;
grant dba to ids_test

6. 导入dmp文件
imp ids_test/glaway123@gldb file=c:\data.dmp  full=y ignore=y