totn Oracle Error Messages

Oracle / PLSQL: ORA-01918 Error Message

Learn the cause and how to resolve the ORA-01918 error message in Oracle.

Description

When you encounter an ORA-01918 error, the following error message will appear:

  • ORA-01918: user name does not exist

Cause

You tried to execute a command that specified a user name or role name that does not exist.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Correct the command and re-execute.

To view a listing of all users, execute the following statement:

SELECT *
FROM ALL_USERS;

To view a listing of all roles, execute the following statement:

SELECT *
FROM DBA_ROLES;