How I resolved ORA-39002: invalid operation --- ORA-39405 during datapump import
Dec 3, 2025 · 5 min read · I 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...
Join discussionDatapump - Exclude table AUD$
Aug 18, 2025 · 3 min read · 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...
Join discussionOracle Data Pump and OCI
Sep 8, 2024 · 4 min read · Oracle 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...
Join discussionGet complete DDL for a schema
Jun 14, 2021 · 4 min read · There 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...
Join discussion