When we are doing the operations like upgrades, patches, and DDL changes the associated schema objects will get invalid. So it is difficult to recompile all the user objects one by one since it ...

The most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces. Here below are the steps: Step 1. find tablespace “BMW” whether ...

Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you can write in ...

Description: In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance.OPatch wasn’t able to find the database ...

Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as a persistent database ...

Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The ...

Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to ...

Scenario : Facing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2 Analysis : While analyzing we came across the parameter ...

Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291, error ...

Scenario: DB node Crashes after upgrading from 12.0 to 19c. Error: 2021-02-04T12:00:15.450521+00:00 Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc: ...