We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in […]
delete duplicate rows from Oracle Read More »
In this post, we will discuss how to drop the Oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdba startup mount (If database not started) create pfile=’/tmp/pfile.ora’ from spfile; Dropping an Oracle database
How to drop the oracle database Read More »
Cutover phase of adop is downtime phase of Online patching cycle. We should ensure no user access is there in that period as application processes are restarted.Before running the cutover command, ensure you are ready to commit to application of the selected patches. Once cutover is complete, it is not possible to revert to
what happens in cutover phase of adop in R12.2 Read More »
How the histograms are generated in EBS Oracle product team decides about the column where histograms are needed and those columns are inserted into the table FND_HISTOGRAM_COLS. FND_STATS collects histogram information if a column is listed in FND_HISTOGRAM_COLS. we should not use DBMS_STATS to gather stats in the EBS database as then it will create
How the histograms are generated in EBS Read More »
In this post, we will be checking out the most commonly used oracle tde wallet queries. How to open a TDE wallet in Oracle 12c or 19c Here is how to open a wallet in Oracle 12c or 19c for both CDB and Non-CDB Databases With 12c Non-CDB ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED
how to open a TDE wallet in Oracle : Status, Open, Close Read More »
In this post, we will discuss FND_FILE in oracle apps, how it works, troubleshooting the FND_FILE issues What is FND_FILE select cp.plsql_dir, cp.plsql_out, cp.plsql_log from fnd_concurrent_requests cr, fnd_concurrent_processes cp where cr.request_id =< running request id> and cp.concurrent_process_id = cr.controlling_manager; l<seq no>.req o<seq no>.req FND_FILE API Procedure FND_FILE.PUTSyntaxFND_FILE.PUT (which IN NUMBER, buff IN VARCHAR2);Arguments which: A
FND_FILE in oracle apps Read More »
