Oracle Tidbits – July 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in July 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c To change a regular user (password authenticated) to schema only account, the user should not have any administrative privileges (SYSDBA, SYSRAC, etc.). Query administrative privileges in … Read more

Oracle Tidbits – June 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in June 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c A shared single client access name (Shared SCAN) enables the sharing of one set of SCAN virtual IPs (VIPs) and Listeners on one dedicated cluster in … Read more

Oracle Tidbits – May 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in May 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c When cloning a non-CDB as a PDB or relocating a PDB, use the DBMS_PDB.EXPORTRMANBACKUP procedure to export RMAN backup metadata into the PDB dictionary, enabling backups … Read more

Oracle Tidbits – April 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in April 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c #Dataguard Broker 18c VALIDATE DATABASE SPFILE performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified … Read more

Oracle Tidbits – March 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in March 2018. You will also see these tidbits on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has … Read more

Oracle Tidbits – February 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in February 2018. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. … Read more

Oracle Tidbits – January 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in January 2018. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. … Read more

Oracle Tidbits – December 2017 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in December 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. … Read more