Multitenant Pills – Change DBID for an existing PDB
When you plug the same PDB many times you have to specify “AS COPY” in the syntax: CREATE PLUGGABLE DATABASE ludo AS CLONE USING ‘/u01/app/oradata/ludo/ludo.xml’; Otherwise, you will get an error similar to: ERROR at line 1: ORA-65122: Pluggable database GUID conflicts with the GUID…
Parallel Oracle Catalog/Catproc creation with catpcat.sql
With Oracle 19c, Oracle has released a new script, annotated for parallel execution, to create the CATALOG and CATPROC in parallel at instance creation. I have a customer who is in the process of migrating massively to Multitenant using many CDBs, so I decided to…
Parallel Oracle Catalog/Catproc creation with catpcat.sql
With Oracle 19c, Oracle has released a new script, annotated for parallel execution, to create the CATALOG and CATPROC in parallel at instance creation. I have a customer who is in the process of migrating massively to Multitenant using many CDBs, so I decided to…