Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing which we can see is to get a descriptive error messages which was not present in earlier Oracle release version. Use ERROR_MESSAGE_DETAILS to control whether the database raises an additional stacked error message, with further details about the data values encountering the … Read more
Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new features, with a focus on three key areas:1. AI for Data2. Dev for Data3. Mission-Critical for Data For the past couple of years, DBA & developers have been accustomed to writing SELECT … FROM DUAL to obtain the result of … Read more
Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch to an Oracle database or software environment. prepatch.sh is executed once each ORACLE_HOME, but there are two different scripts, one for the CRS_HOME and the … Read more
Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions: 1. Administrative These waits occur due to DBA commands that cause users to wait, such as during an index rebuild. 2. Application Waits caused by user application code, like lock waits due to … Read more
Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and other database structures. Compression: Decide whether you’ll use compression during the export process. Compressed exports require less disk space but may take longer to complete. Export Options: Consider any additional options you’ll use during the … Read more
Hey Folks !! Today I have received a client requirement regarding exporting few columns from a table in Oracle 19c. Here are three methods you can use to achieve this:1. Use Create Table As Select (CTAS) to directly create a table with the specific columns you need.2. Utilize the Export and Import functionality, and then … Read more
Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also known as My Oracle Support. There are several reasons why we may need to connect with Oracle Support: Typically, Oracle DBAs are tasked with raising a Technical Service Request (SR), whether it’s for an ongoing … Read more