ORA-01426 After Upgrade to 10g
Oracle seems to have a tendency to make small changes to database code which impacts application in a big way. Sad part is, these changes are not always documented properly.…
Read Full RecipeOracle seems to have a tendency to make small changes to database code which impacts application in a big way. Sad part is, these changes are not always documented properly.…
Read Full RecipeToday I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not…
Read Full RecipeMany times Oracle DBA's are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is…
Read Full RecipeMany times we see an issue like this: SQL> conn / as sysdba ERROR: ORA-01031: insufficient privileges This is a very common and frequent error that can occur after the…
Read Full Recipe32-bit Operating systems provide 4Gb of addressable space to applications. This includes memory for the user application and also for the system. When running Oracle on 32-Bit Windows, we can…
Read Full Recipe1. For ORA-1578: There are two ways in which we can extract the data from a corrupted table: a) Using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS b) Using Event 10231 a) Connect as sysdba user:…
Read Full Recipe