Ceci est une ancienne révision du document !

• création PDB

SQL> create pluggable database "XEPDB1" admin user "PDBADMIN" identified by OraclePDB2024  file_name_convert = ('/opt/oracle/oradata/XE/', '/opt/oracle/oradata/XE/XEPDB1');
	Base de donnees pluggable creee.
 
SQL> show pdbs
	   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
	---------- ------------------------------ ---------- ----------
			 2 PDB$SEED                       READ ONLY  NO
			 3 XEPDB1                         MOUNTED
 
SQL> alter pluggable database "XEPDB1" open read write;
	Base de donnees pluggable modifiee.
 
SQL>  show pdbs
		CON_ID CON_NAME                       OPEN MODE  RESTRICTED
	---------- ------------------------------ ---------- ----------
			 2 PDB$SEED                       READ ONLY  NO
			 3 XEPDB1                         READ WRITE NO

• suppression PDB

ALTER PLUGGABLE DATABASE APP_ROOT_CLONE CLOSE;
DROP PLUGGABLE DATABASE APP_ROOT_CLONE FORCE INCLUDING DATAFILES;