Drop user/schema problem
557426Feb 8 2007 — edited Feb 8 2007Experts,
I'm trying to drop a user/schema in my database. when I try to do that, following error occures. but when I check the currenly active session ther is NO connection for the user RC.
earlier I tryed to drop the user but the user didn't get dropped but only all the objects got dropped. and the dropping command was stuck for 2 hrs and I killed the process manualy.
Please give me a solution for this ....
SQL> drop user RC cascade;
drop user RC cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected