Data-Pump

Run a Consistent Export with expdp FLASHBACK_TIME Purpose A schema export reads many tables over a span of time, and for schemas where rows in one table reference rows in another, you usually want every table in the dump to reflect the same moment. Community Data Pump documentation puts it directly: expdp exports are …

Monitor Data Pump Progress with V$SESSION_LONGOPS Purpose V$SESSION_LONGOPS shows how far a running expdp or impdp job has got. That matters on a full-database export scheduled overnight, or an import that has been running for six hours. The dynamic performance view gives a number to plan around instead of a guess. …

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 …

Monitor Oracle Data Pump Resumable Waits with 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 letting …