Pages

▼
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...
Tuesday, February 1, 2022

impdp error: ORA-39346: data loss in character set

›
============== impdp Error  ORA-39346: data loss in character set   ============== ORA-06512: at "SYS.KUPW$WORKER", line 26274 ORA...
Thursday, January 27, 2022

Golden Gate Datapump is not pushing the files to remote host

›
Issue Golden Gate Datapump is not pushing the files to remote host. Files are generated in source host but not pushed to target host On sour...
Sunday, December 26, 2021

Tuning Golden Extract Memory

›
=============== General =============== Golden Gate Extract was running slow, lag increasing, until it was  several days GGSCI (geqaa-1-aps-...
Wednesday, December 22, 2021

Gather Stats Task

›
================================= What Is The Default Gather Stats Task? ================================= Out of the box, Oracle comes wi...
Sunday, December 12, 2021

When working with FETCH cursor BULK COLLECT INTO, where to put the EXIT WHEN cursor%NOTFOUND; ?

›
============== General ============== When working with  FETCH cursor BULK COLLECT INTO, where to put the   EXIT WHEN cursor%NOTFOUND; ? For...
Monday, December 6, 2021

Drop Obsolete Tablespaces and Datafiles

›
=================== General =================== Drop Obsolete Tablespaces and Datafiles In case table is partitioned, and a TBS is assigned ...