How to move or rename datafiles in Oracle 11gR2

There are multiple ways to move or rename the data files in oracle 11g, oracle 12c has come with a wonderful feature where we can move the files being online. However prior to 12c we need to do this practice after making the database offline, there are online ways are also available but in thoseContinue reading “How to move or rename datafiles in Oracle 11gR2”

CPU, PSU, SPU – Oracle Critical Patch Update Terminology Update

It all started in January 2005 with Critical Patch Updates (CPU).  Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.  As of the October 2012 Critical Patch Update, Oracle has changed the terminology to better differentiate between patch types.  This terminology will be used forContinue reading “CPU, PSU, SPU – Oracle Critical Patch Update Terminology Update”