ORA-65066: The specified changes must apply to all containers

Oracle Container Database and Pluggable Database

When I wanted to change the password on the pluggable database user, I got an error like the one below.

SQL> alter user test identified by test;
alter user test identified by test

ERROR at line 1:
ORA-65066: The specified changes must apply to all containers

View connection information.

SQL> show con_name
CON_NAME
PLUG1

Login as sysdba

SQL> connect / as sysdba
Connected.

Try again

SQL> alter user test identified by test;
user altered.

SQL> show con_name

CDB$ROOT

You can also browse the other article.

Comments