We often need to perform reorganization of the tables. We have to do offline by taking the system down and it consumes a lot of time. we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinition There are some Restrictions Tables with …
Online table redefinition using DBMS_REDEFINITION Read More »
We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in …
In this post, we will discuss how to drop the Oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdba startup mount (If database not started) create pfile=’/tmp/pfile.ora’ from spfile; Dropping an Oracle database …
Cutover phase of adop is downtime phase of Online patching cycle. We should ensure no user access is there in that period as application processes are restarted.Before running the cutover command, ensure you are ready to commit to application of the selected patches. Once cutover is complete, it is not possible to revert to …
In this post, we will discuss, what is a restore point in Oracle, how to check a restore point in Oracle What is a Restore Point in Oracle? Guaranteed restore points Normal Restore Points How to check the restore point in Oracle You can check the restore point in the Oracle database using the below …
Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see How to check Package version in EBS R12 Sometimes, we have …
How to check Package version in EBS R12 Read More »
