IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got ” ORA-01920: user name ‘string’ conflicts with another user or role name ” error in Oracle database.
ORA-01920: user name ‘string’ conflicts with another user or role name
Details of error are as follows.
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.
user name ‘string’ conflicts with another user or role name
This ORA-01920 error is related to attempt creating a user that already exists or attempting to assign a role that has already been assigned.
To solve this error, Specify a different user name.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
ORA-01920: user name ‘OT_SRC_ARUN’ conflicts with another user or role name
HOW can WE DELETE already saved user name in data base and i have to use same user name in schema,
how can be resolve it
run drop username cascade; command