A Seed PDB is actually the PDB$SEED which is an oracle supplied template that the CDB can use to create new PDBs. We are not allowed to add or modify objects in seed PDB.
You can use the CREATE PLUGGABLE DATABASE statement to create a PDB by copying the files from PDB$SEED, which is a template for creating PDBs.
The following SQL statement creates a PDB named crmpdb from the seed using Oracle Managed Files:
CREATE PLUGGABLE DATABASE crmpdb
ADMIN USER karan IDENTIFIED BY mypassword
SQL> alter pluggable database PDB$SEED open;
alter pluggable database PDB$SEED open
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
However any other pdb definately can be dropped or altered.
SQL> alter pluggable database PDB1 open ;
Pluggable database altered.
No comments:
Post a Comment