Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running sql tuning advisor on the particular sql -id in the Cursor cache Create […]
How to rollback the patch after failed cutover phase in R12.2
There may be scenario when cutover phase failed . It is possible to go back to previous state of cutover(rollback the patch) ,if flashback database is either enabled in the database or we have taken full backup prior to cutover I would be explaining it with respect to Database Flashback to rollback the patch I am […]
How to upgrade EBS database to 19c: Step by Step
Here in this post , we wil checking out Upgrading Database to 19c with R12.1 Important points about 19c Upgrade When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to a multitenant architecture, which will consist of a Container Database (CDB) with a single Pluggable Database. Only multitenant architecture […]
How to rollback the Oracle patch
We apply lot of patches to Oracle product to add new feature, to rectify bugs. Sometime the patch do not work as expected and we need to rollback the oracle patch. I am presenting here the rollback cases for different type of Oracle patches Rollback of Database patches Database patches are applied using opatch. Each […]
how to drop table in oracle
The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer available for selection. Dropping a table drops the index and triggers associated with it. Oracle Views, synonym are not dropped but they become invalid Dropped table can be recovered using FLASHBACK utility, if […]
how to delete rows from table in oracle
This SQL tutorial provides explanations, examples for Delete from table in Oracle Delete from table is used in Oracle Sql to delete the rows in the table. It is a DML (Data Manipulation language) statement. It is used to delete the subset of existing rows or all existing rows from the table. Here is the […]