The error "ORA-01920: user name
'string' conflicts with another user or role name" occurs
most
commonly when creating users or assigning roles.
The oerr utility notes this on the ORA-01920 error:
ORA-01920: user name 'string' conflicts with
another user or role name
Cause: There is already a user or
role with that name.
Action: Specify a different user name.
Common causes for the ORA-01920 error include:
- Attempting to create a user that already exists
- Attempting to assign a role that has already been assigned
The ORA-01920: user name 'string' conflicts with another user or
role name prevents the creation of duplicate entries in the
dba_users table. If an ORA-01920 is returned during the
attempted creation of a user, the dba_users table should be queried
to determine what users already exist:
