Data-Pump
Oracle Data Pump: Create the DATA_PUMP_DIR Directory
Apr 11, 2026 / · 5 min read · Oracle Data Pump Database Administration Oracle Backup expdp impdp Directory Object SQL all_directories dba_directories v$parameter ·Oracle Data Pump: Create the DATA_PUMP_DIR Directory Before you can run any Oracle Data Pump export (expdp) or import (impdp) job, Oracle needs to know where to write and read dump files and log files on the server. You do this by creating a directory object inside the database that points to a real folder on the …
Read MoreOracle Resumable Import: Monitor DBA_RESUMABLE View
Mar 4, 2026 / · 5 min read · oracle database data-pump impdp dba-resumable oracle-admin import-export space-management dba_resumable ·Oracle Resumable Import Parameters: Monitor and Manage DBA_RESUMABLE When you run a large Oracle Data Pump import (impdp), the job can fail mid-way if a tablespace runs out of space. Oracle's resumable import feature prevents this by suspending the job instead of failing it, giving you time to fix the problem and then …
Read More