FILE_NAME_CONVERT vs PDB_FILE_NAME_CONVERT
March 3, 2021After last week’s post, I got some feedback from you, my subscribers and readers, and you asked me to elaborate… Continue Reading
Tag: DBA
What Is A Refreshable Clone PDB?
February 20, 2021Did you know you can create a Clone PDB, that can be refreshed at a later time with new data… Continue Reading
What Is Local Undo Mode
January 31, 2021Since I mentioned local undo mode in my previous posts, lots of you asked me to elaborate on it, and… Continue Reading
Creating PDBs By Cloning
January 25, 2021Last post we learned to create PDBs from scratch. This week we will look at creating PDBs by cloning other… Continue Reading
Learn Something New About Alter Table Move
October 21, 2020Imagine that you have a large table, let’s say 500GB in size and 500 million rows in it. You need… Continue Reading
19c LISTAGG Can Do Distinct
October 15, 2020Do you use analytic functions in Oracle? I do not use them as much as I’d like to, but I… Continue Reading
The Story Behind The Ultimate SQL Tuning Formula
September 28, 2020Have you ever wondered why I created The Ultimate SQL Tuning Formula? At the beginning of my career, I remember… Continue Reading
Scripts to Upgrade DB using Export/Import Datapump – Part 1
September 8, 2020In my last blog post, I was showing you one way to upgrade a database to 19c (or to any… Continue Reading
DBMS_QOPATCH How to List the Patches Applied Without Connecting to the Database Server
August 3, 2020Ever wondered how to check what patches are installed for a database home, without actually having access to the database… Continue Reading
Quick and Easy Steps To Change Database Name
April 24, 2020When was the last time you had to change the name of a database? Long time ago, changing the database… Continue Reading