Default: Null


Used to stop the job after it is initialized. This allows the master table to be queried before any data is exported.

Syntax and Description

ABORT_STEP=[n | -1]

The possible values correspond to a process order number in the master table. The result of using each number is as follows:

  • n -- If the value is zero or greater, then the export operation is started and the job is aborted at the object that is stored in the master table with the corresponding process order number.

  • -1 -- If the value is negative one (-1) then abort the job after setting it up, but before exporting any objects or data.


  • None


> expdp hr DIRECTORY=dpump_dir1 DUMPFILE=expdat.dmp SCHEMAS=hr ABORT_STEP=-1