MMichael·Mar 5DBMS_METADATA.GET_DDL not returning password hashes Today I've stumbled over a new behaviour Oracle introduced for function DBMS_METADATA.GET_DDL. Starting with Datapump Bundle Patch 19.17 (which includes fix for bug 33517865), Oracle introduced an imp2 min read·mmuehlbeyer.hashnode.dev
DDavid Sanz·Feb 24[26ai] DBMS_CLOUD — Capitulo DosEl artículo también se encuentra publicado en Ingles English version. Continuando con el artículo de la semana pasada, donde vimos la configuración y unos primeros usos de DBMS_CLOUD en el día a día,3 min read·dbaenlasombra.com
DDavid Sanz·Feb 24[26ai] DBMS_CLOUD — Chapter TwoIf you prefer to read in Spanish Spanish version. Cointinuing with the last article, where we looked at how to set up DBMS_CLOUD in our database and took the firsts steps., today, we're going to see h3 min read·dbaintheshadow.com
OOlamigoke Oyeneyin·Dec 3, 2025How I resolved ORA-39002: invalid operation --- ORA-39405 during datapump importResolve ORA-39002 and ORA-39405 errors during Oracle Data Pump import by upgrading timezone version and patching the target database5 min read·iamgo0ke.hashnode.dev
PPrasenjit Mahato·Aug 18, 2025Datapump - Exclude table AUD$There was a requirement to exclude the AUD$ table of the SYS schema from the export dump.The AUD$ table is already being collected daily in a separate database and retained for three years for reporting purposes. Excluding it from the export avoids r...3 min read·oracledbafindings.hashnode.dev
JJoe Ngo·Sep 8, 2024Oracle Data Pump and OCIGuide to Oracle Data Pump in Oracle Cloud: setup, export, import, job monitoring for DB admins and developers4 min read·devkata.joergeous.one
CConnor McDonald·Jun 14, 2021Get complete DDL for a schemaThere are plenty of tools out there that you can use to get DDL scripts for various objects in the database. However, a lot of them are not ideally suited to automation, because they are driven by wizards or similar developer driven input. Often we h...4 min read·connormcdonald.hashnode.dev