su - oracle
sqlplus / as sysdba
the procedure of dropping user are as follow:
select sid,serial# from v$session where username='DP_REPO';
SID SERIAL#
---------- ----------
122 513
135 14325
140 6581
149 10477
152 34199
alter system kill session '122,513';
alter system kill session '135,14325';
alter system kill session '140,6581';
alter system kill session '149,10477';
alter system kill session '152,34199';
drop user dp_repo cascade;
the procedure of creating user are as follow:
create user dp_repo identified by dp_repo;
alter user dp_repo default tablespace USERS quota unlimited on USERS;
alter user dp_repo temporary tablespace temp;
grant connect to dp_repo;
grant resource to dp_repo;
grant create trigger to dp_repo ;
grant create session to dp_repo ;
grant create sequence to dp_repo ;
grant create synonym to dp_repo ;
grant create table to dp_repo ;
grant create view to dp_repo ;
grant create procedure to dp_repo ;