<div>
Stray thought, perhaps dpownera owns tables, synonyms, or other objects that are in use by other schemas?<br />
That was the case. Tks.
</div>


Stray thought, perhaps dpownera owns tables, synonyms, or other objects that are in use by other schemas?
That was the case. Tks.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im trying to drop a user but its failing and it doesnt have any entry in the v$session..<br />
<br />
SQL&gt; drop user dpownera cascade;<br />
drop user dpownera cascade<br />
*<br />
ERROR at line 1:<br />
ORA-01940: cannot drop a user that is currently connected<br />
<br />
<br />
SQL&gt; select sid, serial# from v$session where username = 'DPOWNERA';<br />
no rows selected<br />
<br />
===<br />
<br />
Is there a way to drop the user and its session in the same command?<br />
<br />
What can I do if there isnt any seesions in the v$session for this user...? Maybe look somewere else?
</div>
</div>


Hi,

Im trying to drop a user but its failing and it doesnt have any entry in the v$session..

SQL> drop user dpownera cascade;
drop user dpownera cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected


SQL> select sid, serial# from v$session where username = 'DPOWNERA';
no rows selected

===

Is there a way to drop the user and its session in the same command?

What can I do if there isnt any seesions in the v$session for this user...? Maybe look somewere else?

Oracle 10g - ORA-01940: cannot drop a user that is currently connected

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.