Oracle Database Discussions

Hi,

I am trying to drop a user from the database but am getting this error in sqlplus

SQL> drop user x cascade ;
drop user x cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

there are only 2 tables in this schema , when I try to drop them manually, I get the same error. initially there were inactive sessions in v$session.
after the user assured me they had closed all database connections I could still see these inactive sessions
by querying

select * from v$session where username = 'x';

so I ran alter system kill session '<sid>,<serial#>'; for all inactive sessions

but now for some reasons I cannot drop this user until the locks on the 2 tables are released. the user is no longer connected to the database but i cannot drop these tables


Is there a way I can drop these tables without shutting down the database? help!