Tuesday, April 9, 2013

Restarting a Data Pump failed Job.


 The solution, however, is simple enough. All you need to do is use the Data Pump Restart Capability:

1)    In the IMPDP window, click CTRL-C to stop the job.


2)    In the command line type:
Import> stop_job=immediate


3)    Use SQLPlus to make the required changes to the table space. You can:
a)    Add DataFile ALTER TABLESPACE <tablespace name> ADD DATAFILE ‘<path to file name and  file name>’ SIZE <integer>M;
b)    Resize the Datafile:
ALTER DATABASE DATAFILE ‘< path to file name and  file name >’ RESIZE <integer>M;

c)     Enable autoextend:
ALTER DATABASE DATAFILE ‘< path to file name and  file name >’ AUTOEXTEND ON MAXSIZE UNLIMITED;

4)    Attach the Job.
>impdp system/manager attach=Job_Name
If you did not provide a specific job name when you first ran the IMPDP, Oracle will assign a default name for it. In order to find the System assigned name for the IMPDP job you can run the following query:

SELECT * FROM DBA_DATAPUMP_JOBS;
The result will probably be something like SYS_IMPORT_FULL_number.

5)     Restart the job
Import> start_job

6)    You can check the status of the job by simply typing STATUS in the utility command prompt.
Import> status

No comments:

Post a Comment