MMichaelinmmuehlbeyer.hashnode.dev·Mar 5 · 2 min readDBMS_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 imp00
DSDavid Sanzindbaenlasombra.com·Feb 24 · 3 min read[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, 00
DSDavid Sanzindbaintheshadow.com·Feb 24 · 3 min read[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 h00
OOOlamigoke Oyeneyininiamgo0ke.hashnode.dev·Dec 3, 2025 · 5 min readHow I resolved ORA-39002: invalid operation --- ORA-39405 during datapump importI had a task to import some table data from a source database with database version 19.23.0.0.0 to target of database version 19.16.0.0.0. Then, I got an error this error ORA-39002: invalid operation ---ORA-39405: Oracle Data Pump does not support im...00
PMPrasenjit Mahatoinoracledbafindings.hashnode.dev·Aug 18, 2025 · 3 min readDatapump - 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...00
JNJoe Ngoindevkata.joergeous.one·Sep 8, 2024 · 4 min readOracle Data Pump and OCIOracle Data Pump is a powerful utility for moving data and metadata between Oracle databases. When combined with Oracle Cloud Infrastructure (OCI), it becomes an even more versatile tool for database administrators and developers. This guide will wal...00
CMConnor McDonaldinconnormcdonald.hashnode.dev·Jun 14, 2021 · 4 min readGet 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...00
