Troubleshooting DROP USER HANGS / ORA-01940 Issues.
(Doc ID 1291804.1)
Last updated on JUNE 25, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Goal
Information in this document applies to any platform.
This article discusses the DROP USER hung (hanging) scenario and DROP USER reporting ORA-01940. Also, the method to diagnose and troubleshoot such issues.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |