Default: Null


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

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 import 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 and the job is an import using a NETWORK_LINK -- Abort the job after setting it up but before importing any objects.

  • -1 and the job is an import that does not use NETWORK_LINK -- Abort the job after loading the master table and applying filters.


  • None


> impdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 LOGFILE=schemas.log