PDB read-only and read-write conversions
1, PDB to mount state sql> alter pluggable database PDB11 close immediate; Pluggable database Altered.2, view pdbsql> show PDBs; con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------ 2 Pdb$seed Read Only NO 3 PDB11 mountedsql> 3, PDB Read Only SQL > sql> Alter PLUGGABLE database PDB11 open Read only; Pluggable database altered. Sql> show PDBs; con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------ 2 Pdb$seed Read Only no. 3 PDB11 Read only nosql> alte R Pluggable Database Pdb11 close immediate; Pluggable database Altered.4, PDB read-write sql> alter pluggable database PDB11 Open read write; Pluggable database altered. Sql> show PDBs; con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------2 pdb$seed READ only NO 3 PDB11 R EAD WRITE nosql>
12CR1 PDB read-only and read-write conversions