Hello, I Ihave installed in my computer the ORACLE XE184 and the SQL Developer 19.2.1 and whenever I tried to create a user I received the following message in red below:
Falha ao processar o comando SQL
- Erro a partir da linha : 2 no comando -
CREATE USER "Teste" IDENTIFIED BY "teste123"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
Relatório de erros -
ORA-65096: nome de atribuição ou de usuário comum inválido
65096. 00000 - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to the
usual rules for user and role names, common user and role names
must consist only of ASCII characters, and must contain the prefix
specified in common_user_prefix parameter.
*Action: Specify a valid common user or role name.
Then I tried to create the user by Putting the character c## before the name, but when I create a new connection and try to use this user, A receive the message that the user is invalid or have the wrong password.
By reading some stuff in the internet I discovered that there are two kinds of users: "Common Users" and "local user". What happens is that I am not being able to try ORACLE DB because the users I create do not work.
Can anyone here help me?
Regards,
Rui