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

Last updated on JULY 20, 2024

Applies to:

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

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