Drop user ORACLE_OCM cascade is giving ORA-01940

(Doc ID 1517405.1)

Last updated on OCTOBER 26, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 SQL> drop user ORACLE_OCM cascade;

drop user ORACLE_OCM cascade
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

There are no sessions for CCR or ORACLE_OCM on any of the instances of the database




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms