Pages

▼
Wednesday, March 30, 2022

_optimizer_nlj_hj_adaptive_join in oracle 19.3

›
 _optimizer_nlj_hj_adaptive_join in oracle 19.3 ============= Symptoms ============= After upgrade to oracle 19.x running a complex query wi...
Monday, March 21, 2022

Data Pump Extract STATS "No active extraction maps".

›
================ Issue ================ In Golden Gate There is no error, but data is not replicating for one of tables defined for P flow C...

Golden Gate - No Replication, Datapump is broken, "No active extraction maps."

›
================ Issue ================ In Golden Gate There is no error, but data is not replicating for one of tables defined for P flow C...

Golden Gate - No Replication, REPLICAT is broken, (Timeout waiting for message)

›
================ Issue ================ In Golden Gate There is no error, but data is not replicating for one of tables defined for P flow C...
Wednesday, March 16, 2022

ORA-32321: REFRESH FAST unsupported after detail table TRUNCATE; ORA-12034: materialized view log younger than last refresh

›
=============== Issue =============== BEGIN  DBMS_REFRESH.REFRESH('MY_USER.GSM_COUNTRIES'); END; / ORA-32321: REFRESH FAST of "...
Sunday, March 6, 2022

Changing Oracle Archive Files Location

›
Need to change /oracle_db/db1/db_igt/arch to /oracle_db/db2/db_igt/arch/ Steps SQL> archive log list Database log mode              Archi...
Sunday, February 13, 2022

expdp fails with error: ORA-31634 and ORA-31664 error

›
===================== expdp fails with error: ORA-31634 and  ORA-31664 error ===================== After running export there sis this error...