Remote PDB Clone: ORA-65180
Published: Sat, 04/03/21
The more databases you clone, the more you learn about the cloning process, and the more challenges you come across. If things always work out as per…
Diana Robete
database advise, step by step guides, how to emails
When to Use MAX_PDBS parameter
Published: Tue, 03/16/21
MAX_PDBS parameter was introduced in 12cR2, to limit the number of pluggable databases (PDBs) one can create in a CDB or in an application root…
FILE_NAME_CONVERT vs PDB_FILE_NAME_CONVERT
Published: Wed, 03/03/21
After last week’s post, I got some feedback from you, my subscribers and readers, and you asked me to elaborate a bit about FILE_NAME_CONVERT and…
What Is A Refreshable Clone PDB?
Published: Sat, 02/20/21
Did you know you can create a Clone PDB, that can be refreshed at a later time with new data from the source database? After creating the Clone PDB,…
What Is Local Undo Mode
Published: Mon, 02/01/21
Since I mentioned local undo mode in my previous posts, lots of you asked me to elaborate on it, and remove the confusion around the local undo in the…
Creating PDBs By Cloning
Published: Mon, 01/25/21
Last post we learned to create PDBs from scratch. This week we will look at creating PDBs by cloning other PDBs. We can create a pluggable database…
How To Create A PDB From Scratch
Published: Tue, 01/12/21
Did you read my last post about the Multitenant Architecture? Today, we are going to go a bit deeper and learn about PDBs and how to create them. PDBs…
Be Part Of The Ultimate SQL Tuning Formula Tribe
Published: Mon, 01/04/21
Is improving your tuning skills in 2021 one of your goals? Did you plan on taking some kind of training, but the budget was/is always tight? I have a…
Intro To Multitenant Architecture
Published: Sat, 01/02/21
I hope all of you had a great winter break! Did you spent some time learning something new? I, personally managed to spend about 4 hours on some…
Happy New Year From DBAParadise!
Published: Fri, 01/01/21
Happy New Year! I am grateful for every single one of you for reading my posts and emails and for supporting dbaparadise.com and The Ultimate SQL…