Data-Pump

Run a Consistent Export with expdp FLASHBACK_TIME Purpose A Data Pump export that reads one table at 02:00 and the next at 02:15 is not a consistent snapshot — it is a photograph taken in pieces over time. For schemas where rows in one table reference rows in another, that time spread means the export can capture …

Monitor Data Pump Progress with V$SESSION_LONGOPS Purpose Where the expdp and impdp log files record a status line per completed object — writing output at each table boundary, not while a large table is mid-transfer — V$SESSION_LONGOPS records progress while the operation is still running. That gap matters on a …

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 …

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 …