I am trying to create a user called PASARELA in which I can assign a tablespace to it in order to use it as a manager, but it gives me the following error:
CREATE USER PASARELA IDENTIFIED BY "Paradise30"
DEFAULT TABLESPACE "RUNWAY"
TEMPORARY TABLESPACE "TEMP"
ENABLE EDITIONS ;
Bug Report - ORA-65096: invalid common user or role name 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.
I am using version 21c express edition of oracle
This error indicates that the connection you are using is pointing to the CDB and not to a PDB. Are you familiar with the change they made in 12c where they introduced the concept of PDBs (pluggable databases)?
Well, it means that your schemas and "program" data should live in a PDB that is easier to maintain and blah, while the DB configuration and jobs metadata and everything that oracle does in the background, lives in the CDB (container database). A CDB may be associated with zero or more PDBs.
This also implies that the restrictions on schemas and other data in the CBD are greater. As in the username you're trying to create, which is very long (yes, that's how strict the CBD world is).
So, you have to connect to the PDB instance that is created by default in the installation (as I remember, it is
XEPDB1
in express edition).