The simplest method is to add a hint to the query to overcome ORA-00001 Added in 11.2, the ignore_row_on_dupkey_index hint silently ignores duplicate values: insert /*+ ignore_row_on_dupkey_index ( acct (…
Read MoreA virtual column applies a function to a column in the table. The database only computes this at runtime. The value is not stored in the table. So instead of…
Read MoreThe smallest unit of data storage in Oracle Database is the block. This defaults to 8k (8,192 bytes). Each index entry must fit within one block. So the maximum size…
Read MoreAPPLIES TO: Oracle WebLogic Server – Version 10.3.6 to 10.3.6 Generic Linux GOAL: If there are a lot of webLogic domains to configure, this document provides an example to define…
Read MoreISSUE: ORA-31693: Table data object “APPLSYS”.”FND_LOBS” failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout ORA-01555: snapshot too old: rollback segment number with…
Read MoreIntroduction: The following script is to validate if there are any corrupted rowids in FND_LOBS table Why we need to do this? When we run this validation script it will…
Read MoreIssue: Concurrent program stuck in OPP Steps to solve the Issue: Query to check concurrent program stuck in OPP SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT FROM…
Read MoreIntroduction: EBS Application patch is applied to upgrade the version of application files Steps to apply Patch in EBS instance: Patch Upgrade in EBS instance: Step 1:…
Read Moreset pagesize 10000 set linesize 133 column tablespace format a20 heading ‘Tablespace Name’ column segfile# format 9,999 heading ‘File|ID’ column spid format 9,999 heading ‘Unix|ID’ column segblk# format 999,999,999 heading…
Read Moreset head on column module format a20 set lines 1000 pages 1000 prompt SQL Ordered by Elapsed time /*FIND THE SNAP ID*/ set pages 0 col begin_interval_time for a30 col…
Read More