Learn the purpose and how to get to the bottom of the ORA-01435 error message in Oracle.
Description
When you come upon an ORA-01435 error, the following error message will appear:
ORA-01435: user does not exist
Cause
You tried to reference a consumer that does now not exist. This most likely befell in a GRANT or REVOKE statement.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Check to make sure that the user exists.
You can locate a listing of all customers with the following SQL statement:
SELECT *
FROM all_users;