Forum Stats

  • 3,839,355 Users
  • 2,262,485 Discussions
  • 7,900,946 Comments

Discussions

Connecting to a PDB using ALTER SESSION SET CONTAINER

Steve_74
Steve_74 Member Posts: 102 Blue Ribbon

DB version: 12c till 19c

OS : Oracle Linux, RHEL 7.x 

I am new to working in multitenant architecture. 

As a DBA, when I want to do some admin tasks in a PDB, I connect to the root container as SYS first and then I issue the following command to 'connect' to the PDB. 

alter session set container=pdb3; 

I have done basic stuff like user management, adding datafile, etc after connecting to the PDB using the above mentioned ALTER SESSION SET CONTAINER method. It seems to be working fine. But, then again, I am new to working in a multi-tenant architecture.

Hence, I would like to know if there are any risks in following the above method, in any special circumstances.

Answers