How To Allow Blank Lines In Your SQL Statements: SQLBLANKLINES
November 2, 2021Today’s post will give you a quick and easy tip. Did it ever happen to you to receive a script… Continue Reading
Tag: Oracle
How To Synchronize Applications
September 27, 2021In previous blog post we talked about maintenance in the application root container. If you remember, I mentioned that the… Continue Reading
Application Upgrade inside the Application Root Container
August 2, 2021In the previous post, we talked about application maintenance within an Application Root Container, specifically an application installation. As promised,… Continue Reading
How To Create An Application Container
June 8, 2021Application Containers can be created in many ways: from the PDB seed, by cloning an existing PDB, or plugging in… Continue Reading
Can You Alter a Datafile From the CDB$ROOT?
May 20, 2021What do you think the answer is? Some of you might be saying YES, of course you can, some of… Continue Reading
5 Things To Know About Application Containers
May 8, 2021I am sure that all of you have heard about Application Containers, but do you really understand what they are,… Continue Reading
When to use MAX_PDBS parameter
March 16, 2021MAX_PDBS parameter was introduced in 12cR2, to limit the number of pluggable databases (PDBs) one can create in a CDB… Continue Reading
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
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