SQL> alter session set container=edwt; ERROR: ORA-01031: insufficient privileges.
– Switch the container using Alter system set container … – Use connect command to connect to PDB using network alias.
1. When trying to set inmemory_size within a PDB when inmemory_size is 0 in the CDB ORA-02096: specified initialization parameter is not modifiable with this option. SQL> alter session set container = cdb$root
alter session set container = kona; set serveroutput off.
ALTER SESSION SET CONTAINER = pdbdev; SELECT tablespace_name FROM dba_tablespaces; ALTER PLUGGABLE DATABASE orabase DEFAULT TABLESPACE oradata
SQL> alter session set container=pdb4_copy; Session altered. SQL> grant set container to pdbadmin; Grant succeeded.
SQL> alter session set container=CDB$ROOT
The problem comes when you want to perform a task within the pluggable database. The simplest way to achieve this is to continue to connect using "/ as SYSDBA", but to set the specific container in your script using the ALTER SESSION SET CONTAINER command.
alter session set container=pdb1; create user apex_public_user identified by apex_public_user; grant select, insert, update, delete on flows_files.WWV_FLOW_FILE_OBJECTS$ to apex_public_user; grant connect to apex_public_user
The first PDB in container is FREE, additional PDB is license option. Startup / Shutdown Summary: Starting CDB (container database) will NOT OPEN PDB (pluggable database).