Database Administration (MOSC)

MOSC Banner

12.2.0.1 : ORA-01920 - "user name '%s' conflicts with another user or role name"

Hi ,

I am unable to create a user who mysteriously disappeared from the database ...

This user U9999 exists neither in DBA_USERS NOR in DBA_ROLES !!!


CREATE USER U99999 IDENTIFIED BY Password 

   DEFAULT TABLESPACE TS_DATA

   TEMPORARY TABLESPACE TEMP_USER

   PROFILE SECURE_PROFILE ;


ORA-01920 - "user name '%s' conflicts with another user or role name"

*Cause:  There is already a user or role with that name.

*Action:  Specify a different user name.


Thanks for Help

GD.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center