Steps to enable recycle bin in oracle 10g and 11g
Posted by Abishek Kathiresan Below are the steps to enable recycle bin in oracle 10 & 11g Step 1: log into sqlplus SQL> SHOW PARAMETER RECYCLEBIN NAME …
Read MorePosted by Abishek Kathiresan Below are the steps to enable recycle bin in oracle 10 & 11g Step 1: log into sqlplus SQL> SHOW PARAMETER RECYCLEBIN NAME …
Read MorePosted by Narasimha Rao.K Oracle Database and Applications Security Audit Part 1 Introduction: Hello Everyone, I would like to start series of write ups/post based on the experience regarding How to…
Read MorePosted by Abishek Kathiresan Here we will see the suspend/resume feature in Oracle Database. ALTER SYSTEM SUSPEND statement stops all input and output (I/O) to datafiles (file header and file…
Read MorePosted by Mahendran Manickam Introduction: In this session we will discuss that how to remane redolog members Steps to be followed: Step1: To complete this requirement you have to shutdown the…
Read MorePosted by Venkateshwaran Govindaraj Introduction: When querying *_TAB_MODIFICATIONS view you should ensure that you run DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO before doing so in order to obtain accurate results. FLUSH_DATABASE_MONITORING_INFO Procedure SQL> exec dbms_stats.FLUSH_DATABASE_MONITORING_INFO;PL/SQL procedure…
Read MorePosted by Narasimha Rao.K Introduction: Some of you might be aware of the Oracle Cloud Market place. But there are certain useful Applications services available for DBAs, APPS DBA or Cloud…
Read MorePosted by Narasimha Rao.K Introduction: The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud Manager from Market Place. Pre-requirement: Have Oracle Cloud account login, and…
Read MorePosted by Hemanth Sathavalli Introduction: When applying OPatches to our Oracle database, we frequently encounter conflicts with the existing patches in our database and we raise an SR with Oracle support…
Read MorePosted by Hemanth Sathavalli Introduction: Customers whose databases are of huge size and if the RMAN backup size is about 2TB or more and when there is no enough space to…
Read MorePosted by Sathiyaseelan Mariappan Hi .. Lets find out the solution for below issue. Issue: Fresh apex install failed with the below error. ORA-38824: A CREATE OR REPLACE command may…
Read More