Error ==== ORA-39166: Object APEX_050100.APEX was not found or could not be exported or imported. ORA-31655: no data or metadata objects selected for job Job “ROOT”.”SYS_EXPORT_TABLE_01″ completed with 2 error(s)…
Read MoreTotal number of attachments per program —————————————– select distinct program_name, count(*) from fnd_lobs group by program_name order by 2 desc; Total number of program with Expiration Date ——————————————— select program_name,count(*)…
Read MoreImportant queries related to workflow 1.Check the status of Notifications: ==================================== col RECIPIENT_ROLE format a20 col FROM_USER format a20 col TO_USER format a20 set lines 170 select NOTIFICATION_ID,MESSAGE_TYPE,MESSAGE_NAME,RECIPIENT_ROLE,STATUS,FROM_USER,TO_USER from wf_notifications…
Read MoreSchema Export and Import from On-premise database to AWS cloud database. Step 1:Connect the on-premise database and the export the schema DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’,…
Read MoreIn Data Guard, for some reason, standby database rule are incorrectly shown as primary database, while primary database shows as standby rule. DGMGRL> show configuration; Configuration - TESTDB Protection Mode:…
Read MoreWhen try to start up an Oracle database, the below errors occur: ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device Additional information:…
Read MoreSymptoms Call to dbms_metadata.get_ddl failed with following error – ORA-04063: package body “SYS.DBMS_METADATA” has errors expdp failed with following error – Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-39126: Worker unexpected fatal error…
Read MoreSymptoms — Problem Statement:Setiting logminer to a specific tablespace reports the following error SQL> create tablespace logmnr_tbs datafile ‘${vtbsp_dir01}/logmnr_tbs01.dbf’ size 700m ;SQL> BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;/2 BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;*ERROR at line…
Read MoreError: ORA-02374: conversion error loading table “SCHEMA”.”TABLENAME” ORA-12899: value too large for column MINE_TEXT (actual: 66, maximum: 64) ORA-02372: data for row: MINE_TEXT : 0X’45737061C3B16F6C2020202020202020202020202020202020′ More About the Error: 1. Used…
Read MoreGoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN() Extract process return error (904, ORA-00904: : invalid identifier) selecting data in ORAUTIL_getCurrentSCN() The goldengate user has been…
Read More