CONTAINER=CURRENT

How to Resolve ORA-65094: invalid local user or role name

by Ed Chen
June 15, 2022July 7, 2022

ORA-65094 Tried to create a common user in the root container (CDB), but it failed with ORA-65094. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> create… Read More »

How to Resolve ORA-65049: Creation of local user or role is not allowed in this container

by Ed Chen
June 13, 2022June 15, 2022

ORA-65049 Tried to create a user in the current container, but it failed with ORA-65049. SQL> create user hr container=current; create user hr container=current *… Read More »

Alter System Scope, SID and Container

by Ed Chen
April 6, 2016October 23, 2022

ALTER SYSTEM SET When we issue ALTER SYSTEM SET to modify parameter, some scope clauses can be used to specify how new value is applied… Read More »