My Oracle Support Banner

ORA-00604 And ORA-01422 When Attempting To Drop Or Truncate Table Or Drop User (Doc ID 2953595.1)

Last updated on JUNE 27, 2023

Applies to:

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

Symptoms

An attempt to DROP a user fails with the following errors:

DROP USER <username> CASCADE;
DROP USER ..... CASCADE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows

There is 1 table owned by the user in question which produces the same errors when attempting to drop or truncate it.

Note 453528.1 was reviewed, however DUAL does not have more than one row.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.