sqlplus / as sysdba
alter pluggable database all open;
alter pluggable database all save state;
col name for a10
select
CON_ID
,NAME
,OPEN_MODE
,RESTRICTED
,APPLICATION_ROOT
,APPLICATION_PDB
,APPLICATION_SEED
,PDB_COUNT
,APPLICATION_ROOT_CON_ID
from v$pdbs
order by CON_ID;
show parameter db_create_file_dest
CREATE PLUGGABLE DATABASE sales2 AS APPLICATION CONTAINER
from sales;
select
CON_ID
,NAME
,OPEN_MODE
,RESTRICTED
,APPLICATION_ROOT
,APPLICATION_PDB
,APPLICATION_SEED
,PDB_COUNT
,APPLICATION_ROOT_CON_ID
from v$pdbs
order by CON_ID;
alter pluggable database sales2 open;
alter pluggable database sales2 save state;