Recently I came across this when I gave a Multitenant workshop at a German customer. As part of the workshop I explained the _ORACLE_SCRIPT
statements you will find in almost all scripts in ?/rdbms/admin
. And one of the DBAs gave me a bright smile. He mentioned: “We use it already everywhere to avoid strange errors”. But be aware when you use _ORACLE_SCRIPT
in scripts. I will explain, why this can be dangerous.

Photo by Justin Chrn on Unsplash
What does _ORACLE_SCRIPT do?
First of all, this is an underscore parameter. Hence, you won’t find it in the Oracle …
Continue reading...